ExcelBanter - IF FORMULAS NEEDED

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF FORMULAS NEEDED (https://www.excelbanter.com/excel-worksheet-functions/150462-if-formulas-needed.html)

Kerri Olsen

IF FORMULAS NEEDED

CELL A3, IF 100 = $25.00, IF < 100 = $25.00 + THE AMOUNT < 100 *.05
--
Kerri

FSt1

IF FORMULAS NEEDED

hi,
see your post under general questions

FSt1

"Kerri Olsen" wrote:

CELL A3, IF 100 = $25.00, IF < 100 = $25.00 + THE AMOUNT < 100 *.05
--
Kerri

Bob Phillips

IF FORMULAS NEEDED

=IF(A3100,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)

"Kerri Olsen" wrote in message
...
CELL A3, IF 100 = $25.00, IF < 100 = $25.00 + THE AMOUNT < 100 *.05
--
Kerri

Kerri Olsen

IF FORMULAS NEEDED

I have it, Thank you
--
Kerri

"Bob Phillips" wrote:

=IF(A3100,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)

"Kerri Olsen" wrote in message
...
CELL A3, IF 100 = $25.00, IF < 100 = $25.00 + THE AMOUNT < 100 *.05
--
Kerri

Dave Thomas

IF FORMULAS NEEDED

What do you want if the amount is exactly $100?

"Kerri Olsen" wrote in message
...
CELL A3, IF 100 = $25.00, IF < 100 = $25.00 + THE AMOUNT < 100 *.05
--
Kerri

All times are GMT +1. The time now is 04:53 PM.