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

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

?

On 29 Gru, 19:32, Kevin wrote:
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

You have a response in excel.misc.

--
__________________________________
HTH

Bob

"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

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

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