×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

eturn data value and manually key in measured units in the same cell

eturn data value and manually key in measured units in the same cell

eturn data value and manually key in measured units in the same cell

(OP)
How can I return a data value and manually key in the measured units in the same cell?

Thanks,

RE: eturn data value and manually key in measured units in the same cell

You can't

Assuming what you're trying to do is to use a calculated value for another calculation and then update the (second) calculation with the measured value, then the cell must include a formula to get the first value and you will erase that by typing the measured value.

What you need to do is to store the calculated value in another cell. You can then:

1. Manually copy the value of the calculated cell across to the other cell.

2. Make a macro with a button to do the same thing

3. Make a third cell select which value to use and use the third cell for the onwards calculation, e.g. if

Cell A1 contains the calculated value
Cell A2 contains the measured value
Cell A3 contains =IF(ISBLANK(A2);A1;A2)

Use The value of cell A3 for the onwards calculation.
If Cell A2 is empty, (no measured value) then the calculated value is used, if A2 is not empty then the measured value is used.

Hope this helps
Regards
Mogens

RE: eturn data value and manually key in measured units in the same cell

mgp is right but you can make a custom format that includes your units as text with the number; e.g.
- select cell
- click on Format, then Cells
  "Format Cells" dialogue/palette comes up
- select "Number" tab
  Intially cells are usually "General" format
- choose desireable format, e.g. "Number"
  Choose number of digits to display, whatever
- now choose "Custom" (should be at bottom of list)
  A format input box (under "Type:") comes up,
  a separate list box below.
  Your number format is shown in the input box
- Type your units as text in quotation marks,
  after the number format, in the input box,
  including a space after the number format, if desired,
  or after the initial quote,
  e.g. 0.00 "amp"
- The newly created format is added to the list box,
  is automatically applied to the existing cell
  when you click OK,
  and can be chosen for other cells using Format - Cells.

The number in the formatted cell is used for onward calculations in other cells, the text isn't involved.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources