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
|