LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Nested Functions Help Swtmelly Excel Worksheet Functions 6 October 13th 08 06:59 PM
Nested IF Functions Kelly Excel Worksheet Functions 4 March 10th 08 02:39 PM
Too many nested IF functions! Skyscan Excel Worksheet Functions 7 July 9th 07 03:22 AM
nested if(and) functions Rohan Excel Discussion (Misc queries) 3 August 12th 05 01:30 AM
Nested IF and MID functions Jan Buckley Excel Worksheet Functions 2 June 16th 05 09:46 PM


All times are GMT +1. The time now is 11:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"