View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brenner Brenner is offline
external usenet poster
 
Posts: 17
Default '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