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 |
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) |