Answered

Westonci.ca offers quick and accurate answers to your questions. Join our community and get the insights you need today. Ask your questions and receive precise answers from experienced professionals across different disciplines. Join our Q&A platform to connect with experts dedicated to providing accurate answers to your questions in various fields.

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 platform. We aim to provide accurate and up-to-date answers to all your queries. Come back soon. Thank you for your visit. We're dedicated to helping you find the information you need, whenever you need it. Westonci.ca is your go-to source for reliable answers. Return soon for more expert insights.