Answered

Discover a world of knowledge at Westonci.ca, where experts and enthusiasts come together to answer your questions. Get quick and reliable answers to your questions from a dedicated community of professionals on our platform. Explore comprehensive solutions to your questions from knowledgeable professionals across various fields on our platform.

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.

Your visit means a lot to us. Don't hesitate to return for more reliable answers to any questions you may have. Thanks for stopping by. We strive to provide the best answers for all your questions. See you again soon. Westonci.ca is your go-to source for reliable answers. Return soon for more expert insights.