IF Statements

[Blob Eye]

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.

 

[njimack]

=d37*if(d37<=3,1,0.8)

 

[Blob Eye]

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.

 

[njimack]

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.

 

[Blob Eye]

Perfect, that did it. Thank you!