# IF Statements

#### Blob Eye

##### New Member
Hey everyone...here's an easy one for you for a Friday I'm trying to create a formula to find 80% of a number if the number is greater than 3. Otherwise, it needs to be equal to said number. Here is what I came up with based on my google searches...but I seem to be missing something. Any ideas?

=IF(D37>3,[=SUM(.8*(D37))],[=D37])

Thanks,

Phil H.

### Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Code:
``=d37*if(d37<=3,1,0.8)``

Thanks Mack, but this provides 80% of D37 all the time. Anything in D37 that is 3 or less needs to be equal to D37. 80% should only take effect over 3. Thank you.

Thanks Mack, but this provides 80% of D37 all the time. Anything in D37 that is 3 or less needs to be equal to D37. 80% should only take effect over 3. Thank you.

I edited my formula after posting, check it now.

Perfect, that did it. Thank you!

Replies
3
Views
365
Replies
5
Views
417
Replies
0
Views
620
Replies
0
Views
715
Replies
1
Views
277

1,203,099
Messages
6,053,527
Members
444,669
Latest member
Renarian

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back