Find the best answers to your questions with the help of IDNLearn.com's knowledgeable users. Receive prompt and accurate responses to your questions from our community of knowledgeable professionals ready to assist you at any time.

See this formula in the cell J32: =IF(OR(I32=""; H32="BAJA"; H32="VACAS");"0";(I32/H32)). It says if I32 is empty, then J32 stays empty, if H32 says "BAJA", then J32 stays empty, and if H32 says "VACAS", then J32 stays empty; if not I32/H32. I would like to add another condition that says if H30 says "FESTIVO," then J32*1.75.

Sagot :

Explanation:

first of all, J32 does NOT stay empty. it receives the string "0", if none of the 3 conditions is true. otherwise it gets the result of I32/H32.

but with what logic do you want to introduce this new condition ?

should that check happen before the checks of I32, H32 ? or after ?

in other words, should J32 be "0", if one of the checks on I32 and H32 are true, and only if all 3 checks fail, we check H30 ? or is it the other way around ?

I assume the first case.

so, your updated statement looks like

=IF(OR(I32=""; H32="BAJA"; H32="VACAS");"0"; IF(H30="FESTIVO";J32*1.75;(I32/H32))

so, we have I32/H32 only as the truly last-last result option. only if everything else fails.