Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula result not displaying correctly
I have a simple formula to compare a result to an upper or lower limit and
display either one of those limits or the actual figure if it falls between the limits. The cell always displays zero, but when I check the formula by clicking the function symbol on the formula bar, it shows the correct result. Why is the cell showing zero when the formula is calculating the correct result? The cell has no conditional formatting, and is formatted as accounting. (Excel XP 2002) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The Formula is displaying, not the result | Excel Discussion (Misc queries) | |||
formula result is not displaying | Excel Discussion (Misc queries) | |||
Formula Result isn't entered correctly in worksheet | New Users to Excel | |||
result of formula not displaying | Excel Worksheet Functions | |||
displaying formula result | Excel Worksheet Functions |