Thread: Formula help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sunnydazy sunnydazy is offline
external usenet poster
 
Posts: 6
Default Formula help

I need a formula for an either/or situation
if the value of the cell in E1 is one then add the value of J1 to the cell J5
or if the value of the cell in E1 is two then add the value of J to the cell
J6.
any help would be appreciated. I've tried everything I could think of.