Todays Date
Hi,
Assuming that B3 either contains a date or is blank then
=IF(B3,C3+D3,"")
FYI -- SUM(C3+D3) is bad technique. Either use SUM(C3:D3) or C3+D3 not
both. Suppose C3 is 1 and D3 is 1 then C3+D3 = 2, then
SUM(2) is 2, but what's the point of summing a single number.
Cheers,
Shane Devenshire
"T. Valko" wrote in message
...
You haven't explained how today's date relates to what you want so I can't
tell you why:
=IF(B3<=TODAY(),C3+D3,"") ... that does not work for [you].
Maybe this:
=IF(B3="","",C3+D3)
--
Biff
Microsoft Excel MVP
"Kevin" wrote in message
...
I need help with a formula. In Column B I will have a date. In column E I
will have a total of C and D. Right now, in E I am using =SUM(C3+D3). If
I do
not have a Date entry in B I do not want E to show. I tried
=IF(B3<=TODAY(),C3+D3,"") But that does not work for me. Any suggestions?
I am using Excel 2007
|