IF THEN ...

[COOT]

hello... im trying to work out a formula that adds a fee if a cell is above or below a dollar amount. so if cel K4 is over $10 then a fee of .40 is applied to cell O4, AND if cell K4 is under $10 then a .30 fee is applied to cell O04.

basically if a sale is less than $10 dollars that cell should have .30 in it, and if its over $10 it would have .40 in it.

 

[dreid1011]

Perhaps

=IF(K4>10,.4,.3)

What if K4 is exactly $10?

Maybe

=IF(K4>=10,.4,.3)

 

[COOT]

Perhaps

=IF(K4>10,.4,.3)

What if K4 is exactly $10?

Maybe
[

Perhaps

=IF(K4>10,.4,.3)

What if K4 is exactly $10?

Maybe

=IF(K4>=10,.4,.3)

sweet. I was over thinking it. thank you it works!

 

[COOT]

Perhaps

=IF(K4>10,.4,.3)

What if K4 is exactly $10?

Maybe

=IF(K4>=10,.4,.3)

uh oh. ok so that worked great but I didn't account for K4 being blank. if K4 is blank then O4 should remain at zero until K4 is populated.

 

[Joe4]

uh oh. ok so that worked great but I didn't account for K4 being blank. if K4 is blank then O4 should remain at zero until K4 is populated.

Then try:

=IF(K4="",0,IF(K4>10,.4,.3))

 

[COOT]

Then try:

=IF(K4="",0,IF(K4>10,.4,.3))

love it!!! thank you!!!

 

[Joe4]

You are welcome. Just a variation of dreid1011's initial response.
Glad we were able to help!