|The syntax of If Function is:|
=IF (Logic_Test, Value_if_True, Value_if_False)
So your formula should look like;
=IF(A2<="80" , "80" , A2)
If cell a2 has a value of 200, then I would want 80 to be the result. If the cell a2 has a value of 12.75, then I would want the result to be 12.75.
This one requires a Nested IF
which simply means one of the Values_if's
is another IF statement:
=IF(A2=200 , 80 , IF(A2=12.75 , A2 , ""))
If the only two values that will ever be input into A2 are 200 or 12.75
the above can be shortened to something similar to the first formula:
=IF(A2=200 , 80 , A2 )
Does that help?
edited by moderator: SpellCheck