Answer the question
In order to leave comments, you need to log in
How to set a conditional function in Excel to check the result?
Help to make such a function in Excel.
I have a width and a height - let's denote them as a and b respectively.
If, multiplying these variables a by b, we get the result less than 0.5, then the result will be 10.
If, multiplying these variables a by b, we get the result greater than 0.5, then the result will be the expression a * b * 10 Ie ., if (a*b) <= 0.5, then the result will be 10, and if (a*b) > 0.5, then the result will be "result*10".
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question