| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
'Value_If_True' vs. 'Value_If_False'
How do I reference other cells in the "Value If True" and "Value If False"?
Example: Formula is in A10 and it reads like this... =IF(A5=TODAY(),B10=25,C10=50) So - if A5 is equal to Today(), then the # 25 will be placed in B10. If the A5 is not equal to Today(), then the # 50 will be placed in C10. When I'm typing in the formula - it seems that all the cells are referenced as I type them in both the 'value_if_true' spot and the 'value_if_false' spot in the formula - but the result is ALWAYS -- A5 = FALSE. That's all I ever get. False in the original cell. Kindest Regards, John Brenner |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need help with 'value_if_true' | Excel Discussion (Misc queries) | |||
| value_if_false returns formula | Excel Worksheet Functions | |||
| results of value_if_false = no change to cell | Excel Worksheet Functions | |||
| IF function with value_if_true and value_if_false as equations | Excel Worksheet Functions | |||
| Value_if_true | Excel Worksheet Functions | |||
Threaded Mode
