Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help
Maybe
=IF(E1=1,J1+J5,IF(E1=2,J1+J6,"")) Mike "sunnydazy" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|