returning blank cell when conditions not met

Entered into G7 the following
=IF(F7<3,3-F7,0)

F7 is the SUM of C7,D7,E7

If there are no entries in C7,D7 and E7 I want G7 to be blank.
meaning until there are numbers entered I don't want to see 0 in G7
Any ideas. Since i can't seem to find a way to put in an else statement with
excel 2003

TomHutchins
Fri Mar 14 18:26:04 CDT 2008

Try

=IF(AND(LEN(C7)>0,LEN(D7)>0,LEN(E7)>0),IF(F7<3,3-F7,0),"")

Hope this helps,

Hutch

"kfarley" wrote:

>
> Entered into G7 the following
> =IF(F7<3,3-F7,0)
>
> F7 is the SUM of C7,D7,E7
>
> If there are no entries in C7,D7 and E7 I want G7 to be blank.
> meaning until there are numbers entered I don't want to see 0 in G7
> Any ideas. Since i can't seem to find a way to put in an else statement with
> excel 2003

Dave
Fri Mar 14 18:30:23 CDT 2008

=if(count(c7,d7,e7)<3,"",if(f7<3,3-f7,0))
or
=if(count(c7,d7,e7)<3,"",max(3-f7,0))



kfarley wrote:
>
> Entered into G7 the following
> =IF(F7<3,3-F7,0)
>
> F7 is the SUM of C7,D7,E7
>
> If there are no entries in C7,D7 and E7 I want G7 to be blank.
> meaning until there are numbers entered I don't want to see 0 in G7
> Any ideas. Since i can't seem to find a way to put in an else statement with
> excel 2003

--

Dave Peterson

BoniM
Fri Mar 14 18:31:01 CDT 2008

With this entered in cell G7

=IF(AND(C7="",D7="",E7=""),"",IF(F7<3,3-F7,0))

if C7:E7 are blank, G7 should be blank as well....
but with your formula, you should have seen 3 in the cells with no entries
in C7:E7.
if you want F7 to be blank instead of displaying a zero, in cell F7 enter
the following formula:

=IF(AND(C7="",D7="",E7=""),"",SUM(C7:E7))

"kfarley" wrote:

>
> Entered into G7 the following
> =IF(F7<3,3-F7,0)
>
> F7 is the SUM of C7,D7,E7
>
> If there are no entries in C7,D7 and E7 I want G7 to be blank.
> meaning until there are numbers entered I don't want to see 0 in G7
> Any ideas. Since i can't seem to find a way to put in an else statement with
> excel 2003

kfarley
Mon Mar 17 17:24:00 CDT 2008

Thanks guys I'll give it a try.

"kfarley" wrote:

>
> Entered into G7 the following
> =IF(F7<3,3-F7,0)
>
> F7 is the SUM of C7,D7,E7
>
> If there are no entries in C7,D7 and E7 I want G7 to be blank.
> meaning until there are numbers entered I don't want to see 0 in G7
> Any ideas. Since i can't seem to find a way to put in an else statement with
> excel 2003