Answered

Westonci.ca offers fast, accurate answers to your questions. Join our community and get the insights you need now. Get quick and reliable solutions to your questions from a community of experienced experts on our platform. Connect with a community of professionals ready to help you find accurate solutions to your questions quickly and efficiently.

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 :

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.

Thanks for using our service. We aim to provide the most accurate answers for all your queries. Visit us again for more insights. Thanks for using our platform. We aim to provide accurate and up-to-date answers to all your queries. Come back soon. Westonci.ca is your go-to source for reliable answers. Return soon for more expert insights.