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