V
V
vladislavik952018-11-09 23:44:57
excel
vladislavik95, 2018-11-09 23:44:57

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

1 answer(s)
H
Hanneman, 2018-11-10
@vladislavik95

Use Formulas->Logical->IF
5be6859b52225995996236.png

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question