FORMULA NEEDED
IF CELL A2 IS LESS THAN 100 = $25.00, IF GREATER THAN 100= $25.00 + THE
AMOUNT OVER 100 *.05 -- Kerri |
FORMULA NEEDED
try
= 25+max(0,(A2-100)*.05) "Kerri Olsen" wrote: IF CELL A2 IS LESS THAN 100 = $25.00, IF GREATER THAN 100= $25.00 + THE AMOUNT OVER 100 *.05 -- Kerri |
FORMULA NEEDED
Hi Kerri,
Look he http://www.mcgimpsey.com/excel/variablerate.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Kerri Olsen" wrote in message ... | IF CELL A2 IS LESS THAN 100 = $25.00, IF GREATER THAN 100= $25.00 + THE | AMOUNT OVER 100 *.05 | -- | Kerri |
FORMULA NEEDED
hi,
try this... =IF(A2<=100,25,(A2-100)*0.05+25) regards FSt1 "Kerri Olsen" wrote: IF CELL A2 IS LESS THAN 100 = $25.00, IF GREATER THAN 100= $25.00 + THE AMOUNT OVER 100 *.05 -- Kerri |
FORMULA NEEDED
While you are at it have a look here, especially the part about typing in
CAPS http://dts-l.org/goodpost.htm -- Don Guillett Microsoft MVP Excel SalesAid Software "Kerri Olsen" wrote in message ... IF CELL A2 IS LESS THAN 100 = $25.00, IF GREATER THAN 100= $25.00 + THE AMOUNT OVER 100 *.05 -- Kerri |
FORMULA NEEDED
Thank you this worked.
-- Kerri "FSt1" wrote: hi, try this... =IF(A2<=100,25,(A2-100)*0.05+25) regards FSt1 "Kerri Olsen" wrote: IF CELL A2 IS LESS THAN 100 = $25.00, IF GREATER THAN 100= $25.00 + THE AMOUNT OVER 100 *.05 -- Kerri |
All times are GMT +1. The time now is 12:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com