How can I do this IF statement in Excel?

Question

i want to create an IF statement in excel. if the percentage is over 50% then it is flaccid and if the percentage is under 50% it is turgid. how do i write an IF statement for this?

Answer 1

=IF(A1>50%,"flaccid","turgid")

Answer 2

This formula assumes that your numerical values are in column A. Paste the formula (see below, i.e., =IF(A1>= 50,"turgid","flaccid") in cell B1. Then click left click cell B1 in the bottom right hand corner and drag the "box" down until the end of the column (i.e., the cell in column B where the numerical data ends in column A.) NOTE: I have assumed that the formula should return a value of "turgid" when the value in column A is greater than OR equal to 50. If a value of 50 should return a result of "flaccid", remove the equal sign from the formula and proceed as previously described. When posted, the site messes up my formatting. The numerical data should be in column A. The formula goes in column B. Numbers one through six represent the row number.



A B

1 40 =IF(A1>= 50,"turgid","flaccid")

2 45

3 20

4 50

5 60

6 80

Answer 3

Hello Danielle D,



Just use the value with the % sign



=IF(A1<50%,"flaccid",IF(A1>50%,"turgid",A1))



I'm assuming you are referring to words, (flaccid , or turgid) else you need to describe more about being flaccid, or being turgid.



Hope this helps,

dtcom

Answer 4

Go to the How-to Excel Home Page on the main Microsoft site where they have videos showing, in detail, how to use the IF function.