Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF Issue
Hello,
I am trying to verify mathematical results. My approach is something like: (in a Cell) =IF(V4=K4,"Yes","NO") The problem seem to be that the IF function sees that a formula yielding : 398.8072513 is not = to a cell containing the value: 398.8072513 This seems counterintuitive. Is there a way to get IF to evaluate the displayed values of the cells instead of the comparing the 'formulae'? Thanks, mklapp |
#2
|
|||
|
|||
Hi
I think that 'counterintuitive' is a brilliant description!! Two options spring to mind: Use the ROUND function to round the figures. Go to Tools|Options|Calculation and set Precision As Displayed. WARNING - this will set all figures on the spreadsheet to be exactly as they show - and hence lose decimal places that are not displayed. -- Andy. "mklapp" wrote in message ... Hello, I am trying to verify mathematical results. My approach is something like: (in a Cell) =IF(V4=K4,"Yes","NO") The problem seem to be that the IF function sees that a formula yielding : 398.8072513 is not = to a cell containing the value: 398.8072513 This seems counterintuitive. Is there a way to get IF to evaluate the displayed values of the cells instead of the comparing the 'formulae'? Thanks, mklapp |
#3
|
|||
|
|||
Your actual issue here, is that the formula is returning a value that is
*different* from the value contained in the other cell ... BUT ... your formatting of the formula cell is *only* displaying 7 decimal places. The proper approach would be to Round() the return of the formula. i.e.: Revise =A1*B1 To =ROUND(A1*B1,7) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "mklapp" wrote in message ... Hello, I am trying to verify mathematical results. My approach is something like: (in a Cell) =IF(V4=K4,"Yes","NO") The problem seem to be that the IF function sees that a formula yielding : 398.8072513 is not = to a cell containing the value: 398.8072513 This seems counterintuitive. Is there a way to get IF to evaluate the displayed values of the cells instead of the comparing the 'formulae'? Thanks, mklapp |
#4
|
|||
|
|||
Great, it works. I am so glad It is not what I thought it was. Thanks.
"RagDyeR" wrote: Your actual issue here, is that the formula is returning a value that is *different* from the value contained in the other cell ... BUT ... your formatting of the formula cell is *only* displaying 7 decimal places. The proper approach would be to Round() the return of the formula. i.e.: Revise =A1*B1 To =ROUND(A1*B1,7) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "mklapp" wrote in message ... Hello, I am trying to verify mathematical results. My approach is something like: (in a Cell) =IF(V4=K4,"Yes","NO") The problem seem to be that the IF function sees that a formula yielding : 398.8072513 is not = to a cell containing the value: 398.8072513 This seems counterintuitive. Is there a way to get IF to evaluate the displayed values of the cells instead of the comparing the 'formulae'? Thanks, mklapp |
#5
|
|||
|
|||
Appreciate the feed-back, but ... you've piqued my curiosity now ... what
did you actually *think* the problem was? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "mklapp" wrote in message ... Great, it works. I am so glad It is not what I thought it was. Thanks. "RagDyeR" wrote: Your actual issue here, is that the formula is returning a value that is *different* from the value contained in the other cell ... BUT ... your formatting of the formula cell is *only* displaying 7 decimal places. The proper approach would be to Round() the return of the formula. i.e.: Revise =A1*B1 To =ROUND(A1*B1,7) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "mklapp" wrote in message ... Hello, I am trying to verify mathematical results. My approach is something like: (in a Cell) =IF(V4=K4,"Yes","NO") The problem seem to be that the IF function sees that a formula yielding : 398.8072513 is not = to a cell containing the value: 398.8072513 This seems counterintuitive. Is there a way to get IF to evaluate the displayed values of the cells instead of the comparing the 'formulae'? Thanks, mklapp |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Issue (Mixde Fields) | Excel Discussion (Misc queries) | |||
An issue when sorting in excel PivotTable | Excel Discussion (Misc queries) | |||
Excel Viewer performance issue | Excel Discussion (Misc queries) | |||
New Excel Comment Box Issue | Excel Discussion (Misc queries) | |||
Shared File & Freeze panes issue | Excel Discussion (Misc queries) |