More than one IF Statement
I need a formula that will look at cells k125:k127 and if the cells are "Yes"
then subtract A125 from D23 and so on for K126 and K127. If cells K125:K127
are not "Yes" then subtract A93 from d23. It works if K125 is "Yes", but if
K125:k127 are not "Yes" it returns #Value!, when it should subtract A93 from
D23. Also, if K125 is "Yes", and k126 is "Yes" it returns a -1, when it
should return 0 (d23 will be the same number as K125, k126, and k127, so the
number should be 0).
There probably is an easier formula - Please help.
=IF(K125="Yes",(A125-D23),(A93-D23,IF(K126="Yes",(A126-D23),(A93-D23,IF(K127="Yes",(A127-D23),(A93-D23))))))
|