Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |