| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula window displays correct answer while cell displays incorre
The formula : =SUM(IF($O$6:$O$10=O10,1,0)) in the formula window diplays the
correct answer of 2.000. The range does have 2 numbers that are greater or equal to 010. The cell were the formula resides displays 1.000. Unable to figure out why. Formula does work in previous year worksheet. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display answer only in another cell of one containing a formula | Excel Discussion (Misc queries) | |||
| How is it that a cell can transfer the correct formula, but the w. | Excel Discussion (Misc queries) | |||
| Formula displays does not calculate | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| Conditional Formatting for dates | Excel Worksheet Functions | |||
Threaded Mode
