Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula bar deception
I have a nested formula that I am trying to enter into a cell. When I enter
it into the formula bar, the 'Formula Result' is as I expect but when I hit 'OK', the number displaying in the cell is different and apparently random. I've tried recalculating, retyping, simplifying (nested IF functions), all to no avail. The formula bar always looks right and the cell displays wrong. (It's not a rounding error, I'm trying to get a specific single-digit number and I get a different single-digit number.) Help me please! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |