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

I have an "either or" situation:
If cell E1 is 1 then add the entry in J1 to cell J5, or
If cell E1 is 2 then add the entry in J1 to cell J6
This solution was posted yesterday, but it didn't work.

=IF(E1=1,J1+J5,IF(E1=2,J1+J6,""))

Any suggestions would be greatly appreciated.
Thank you,
Sherry