Answer the question
In order to leave comments, you need to log in
The IF function does not accept a value, how to fix it?
Dear experts, all the best!
Please tell me how to write the formula:
A1, B1, C1
(C1=any numerical value)
The task is this:
If A1=100%, then B1=0, otherwise B1=C1
Tried to use this formula: =IF(A1=" 100%";2-2;C1), but this option is not working due to the fact that the IF function does not take a digital value. With a literal value, everything works.
Thank you.
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