| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF FORMULAS NEEDED
CELL A3, IF 100 = $25.00, IF < 100 = $25.00 + THE AMOUNT < 100 *.05
-- Kerri |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help needed on Date formulas | Excel Worksheet Functions | |||
| Help With Formulas Needed | Excel Worksheet Functions | |||
| Help needed on formulas | New Users to Excel | |||
| expert with formulas needed again | Excel Discussion (Misc queries) | |||
| Tricky formulas needed | Excel Worksheet Functions | |||
Hybrid Mode
