[Solved] Help with IF..Then

acidblue · General User Joined: 24 Apr 2012 Posts: 7

I'm having a heck of a time trying to figure out the IF..THEN statement.

I have a cell that is a percentage if that percentage is over 75% I want to print in another cell
100%.

Been trying this: =IF(F3>=75,100,1)
Which doesn't work.

IF the cell F3 is equal to or over 75% I want the to print 100% in cell H3.
If F3 isn't over or equal to 75% I want it to stay the same original value.
I've different variations of the above formula but can't get right.

Tagged as solved - floris v, moderator

Villeroy · Posted: Fri Apr 27, 2012 1:15 pm Post subject:

75% is just another way to write 0.75 or 75/100
75 is equivalent to 7500%
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

JohnV · Posted: Fri Apr 27, 2012 1:20 pm Post subject:

A percentage is just a format of a cell but the under lying value is .75 for 75%.
=IF(F3>=0.75;100;1)

Note that I'm using OOo so my formula uses semi-colons instead of commas.

acidblue · General User Joined: 24 Apr 2012 Posts: 7

AHA!
Thanks, I didn't realize I had to change 75 to 0.75.