Thread: Todays Date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire Shane Devenshire is offline
external usenet poster
 
Posts: 857
Default 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