K
Kerri Olsen
CELL A3, IF > 100 = $25.00, IF < 100 = $25.00 + THE AMOUNT < 100 *.05
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
FSt1
hi,
see your post under general questions
FSt1
see your post under general questions
FSt1
B
Bob Phillips
=IF(A3>100,25,25+(100-A3)*.05)
not really sure that you want the difference between A3 and 100, but it is
not clear to me.
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
not really sure that you want the difference between A3 and 100, but it is
not clear to me.
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
K
Kerri Olsen
I have it, Thank you
--
Kerri
--
Kerri
Bob Phillips said:=IF(A3>100,25,25+(100-A3)*.05)
not really sure that you want the difference between A3 and 100, but it is
not clear to me.
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
D
Dave Thomas
What do you want if the amount is exactly $100?