ExcelBanter - Formula help

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula help (https://www.excelbanter.com/excel-discussion-misc-queries/190129-formula-help.html)

sunnydazy

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.

Mike H

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.

All times are GMT +1. The time now is 04:31 PM.