Problem I need Help With -- IF Statments
 

Have a spreadsheet that I need some help with. The spreadsheet has 5 columns
(a,b,c,d,and e). What I need to do is if there is a number entered in a,b,or
c then e needs to =d. If there is no number the cell remains blank. Have
tinkered with this a number of ways and not finding a good solution.

Ideas? Appreicate the help.


--
debra

Problem I need Help With -- IF Statments
 

Give this a try. This formula goes in cell E1...

=IF(OR(ISNUMBER(A1), ISNUMBER(B1), ISNUMBER(C1)),D1, "")
--
HTH...

Jim Thomlinson


"debra" wrote:

Have a spreadsheet that I need some help with. The spreadsheet has 5 columns
(a,b,c,d,and e). What I need to do is if there is a number entered in a,b,or
c then e needs to =d. If there is no number the cell remains blank. Have
tinkered with this a number of ways and not finding a good solution.

Ideas? Appreicate the help.


--
debra

Problem I need Help With -- IF Statments
 

I'm not sure if this is the cleanest way, but you can try the following
formula in cell E1:

=IF(OR(COUNT(A1)<0,COUNT(B1)<0,COUNT(C1)<0),D1, "")

I'm using the COUNT() function to look for numbers by setting it not equal
to zero, so it will ignore any non-numbers. If any of the columns a, b, or c
has a number in it, column e will return whatever is in d, otherwise it will
leave it blank.


"debra" wrote:

Have a spreadsheet that I need some help with. The spreadsheet has 5 columns
(a,b,c,d,and e). What I need to do is if there is a number entered in a,b,or
c then e needs to =d. If there is no number the cell remains blank. Have
tinkered with this a number of ways and not finding a good solution.

Ideas? Appreicate the help.


--
debra

Problem I need Help With -- IF Statments
 

In E2 put the formula =IF(OR(ISNUMBER(A2),ISNUMBER(B2),ISNUMBER(C2)),D2, "")
--
David Biddulph

"debra" wrote in message
...
Have a spreadsheet that I need some help with. The spreadsheet has 5
columns
(a,b,c,d,and e). What I need to do is if there is a number entered in
a,b,or
c then e needs to =d. If there is no number the cell remains blank. Have
tinkered with this a number of ways and not finding a good solution.

Ideas? Appreicate the help.


--
debra