Todays Date

[Kevin]

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

 

[Bob Phillips]

You have a response in excel.misc.

 

[Jarek Kujawa]

=IF(AND(B3>0,B3<=TODAY()),C3+D3,"")

?

 

[T. Valko]

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)

 

[Shane Devenshire]

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(C33) 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

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

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