Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF statements
I want to evaluate a cell reference to determine if the amount is <= 2400.
If the amount 2400 then multiply the amount by .25 If the amount <= 2400 then subtract 265 and multiply the difference by .25 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF statements
Did you look in the help index for IF? Try =if(a22400,a3*.25,(a3-265)*.25) or if(a2<=2400,a3-265,a3)*.25 -- Don Guillett SalesAid Software "TwoDot" wrote in message ... I want to evaluate a cell reference to determine if the amount is <= 2400. If the amount 2400 then multiply the amount by .25 If the amount <= 2400 then subtract 265 and multiply the difference by .25 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF statements
One way:
= (A1 - 265 * (A1<=2400)) * 0.25 In article , TwoDot wrote: I want to evaluate a cell reference to determine if the amount is <= 2400. If the amount 2400 then multiply the amount by .25 If the amount <= 2400 then subtract 265 and multiply the difference by .25 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF statements
Hi:
if the value is in cell A1: =if(A12400,A1/4,(A1-265)/4) or: =if(A12400,A1,A1-265)/4 -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "TwoDot" wrote: I want to evaluate a cell reference to determine if the amount is <= 2400. If the amount 2400 then multiply the amount by .25 If the amount <= 2400 then subtract 265 and multiply the difference by .25 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF statements
=IF(ISNUMBER(A1),IF(A1<=2400,(A1-265)*0.25,IF(A12400,A1*0.25,"")),"Cell
contains TEXT") Vaya con Dios, Chuck, CABGx3 "TwoDot" wrote in message ... I want to evaluate a cell reference to determine if the amount is <= 2400. If the amount 2400 then multiply the amount by .25 If the amount <= 2400 then subtract 265 and multiply the difference by .25 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need more than 7 nested "IF" statements in Excel" | Excel Discussion (Misc queries) | |||
Returning text from nested IF and Vlookup statements | Excel Worksheet Functions | |||
UDFunctions and nested If-the-else statements | Excel Worksheet Functions | |||
multiple nested IF statements | Excel Worksheet Functions | |||
Nested IF statements | Excel Worksheet Functions |