Problem I need Help With -- IF Statments

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Give this a try. This formula goes in cell E1...

=IF(OR(ISNUMBER(A1), ISNUMBER(B1), ISNUMBER(C1)),D1, "")
 
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.
 
Back
Top