Ask Your Question

formula for 3 cells [closed]

asked 2013-05-20 13:51:24 +0200

R-Canzius gravatar image

updated 2013-05-20 14:00:30 +0200

=IF(G81+J81=0,0,2) OK, I want to add another cell to this formula which will calculate that cell and return its value in cell X eg: =IF(G81+J81=0,0,2) if(I81=0,0,1)so in other words 2 cells will return 0 or 2 and the other cell return 0 or 1, how do I include the other cell ?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-01 13:58:52.135072

1 Answer

Sort by » oldest newest most voted

answered 2013-05-20 14:56:19 +0200

ROSt52 gravatar image

@R-Canzius - I am not exactly sure about the formula you would like to have thus only a bit of a vague answer.

Look into the AND formula and combine it with the IF -function. Most likely you will need to create a formula like =IF(AND....

edit flag offensive delete link more

Question Tools


Asked: 2013-05-20 13:51:24 +0200

Seen: 33 times

Last updated: May 20 '13