How to add multiple arguments in a IF function

[mdean32]

Do I use if function to accomplish this? Cell R2 will always have a value between 1 and 30

if cell F2>27, and cell R2>24, then add 5 to cell Z2.
if cell F2>27, and cell R2<6, then subtract 5 from cell Z2.
if cell F2>27, and cell R2>5,R2<11, then subtract 3 from cell Z2.

If it is false, then I want it to return the value of Z2


Thanks for any help you could offer me.

[oeldere]

You could try this one

=if(and(F2>2,R2>24),z2+5,if(and(F2>2,R2<6),z2-5,Z2))

[Ace_XL]

Maybe..

=Z2+(F2>27)*LOOKUP(R2,{1,6,25},{-5,-3,5})

[mdean32]

thanks guys, it worked....

[FDibbins]

mdean, welcome to the forum

For future reference, please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?