How to get an "IF statement to give me the results needed in my spreadsheet. Below is the formula I have tried. Example : 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.

=IF(a2<="80", "80"), IF(A2>"80", a2))

Your bracket start-finish count doesn't match. Wait for someone more expert if this doesn't work out, but try removing the last bracket.

EDIT: Also see this:

http://fiveminutelessons.com/learn-...

Alwayspop back and let us know the outcome - thanks

message edited by Derek

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

NestedIF

which simply means one of theValues_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?

MIKE

edited by moderator: SpellCheck

Ask Your Question

Weekly Poll