Answered

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.



Answer :

reinhard10158

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.

Other Questions