View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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