Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF functions
I cannot seem to get my head around creating this function. I am trying to
create a pricing algorithm and cannot figure out the correct sequence of writing the function. Here is what i am up against: IF J3<$24.99 then add J3 plus $10.00 IF J3$25.00 but < $49.99 then add J3 plus $15.00 IF j3$50.00 then add J3 plus $20.00 Can this be written to one cell and if so how? -- Thank you for your help, it is greatly appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF functions
=IF(J3<=24.99,J3+10,IF(J3<=49.99,J3+15,J3+20))
I assumed equal to in these... "is2cu" wrote: I cannot seem to get my head around creating this function. I am trying to create a pricing algorithm and cannot figure out the correct sequence of writing the function. Here is what i am up against: IF J3<$24.99 then add J3 plus $10.00 IF J3$25.00 but < $49.99 then add J3 plus $15.00 IF j3$50.00 then add J3 plus $20.00 Can this be written to one cell and if so how? -- Thank you for your help, it is greatly appreciated. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF functions
Hi,
You question lacka clarity IF J3$25.00 but < $49.99 then add J3 plus $15.00 IF j3$50.00 then add J3 plus $20.00 what if J3=50? I have assumed you meant =50 =LOOKUP(J3,{0,25,50},{10,15,20})+J3 Mike "is2cu" wrote: I cannot seem to get my head around creating this function. I am trying to create a pricing algorithm and cannot figure out the correct sequence of writing the function. Here is what i am up against: IF J3<$24.99 then add J3 plus $10.00 IF J3$25.00 but < $49.99 then add J3 plus $15.00 IF j3$50.00 then add J3 plus $20.00 Can this be written to one cell and if so how? -- Thank you for your help, it is greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested Functions Help | Excel Worksheet Functions | |||
Nested IF Functions | Excel Worksheet Functions | |||
Too many nested IF functions! | Excel Worksheet Functions | |||
nested if(and) functions | Excel Discussion (Misc queries) | |||
Nested IF and MID functions | Excel Worksheet Functions |