Nested if function

February 6, 2012 at 03:54:07
Specs: Windows XP
Hi I want to create a price calculator that looks like:

4 25000
5 No of users 5 1000
6 Total Price (formula here) 750
7 500

This is the price:
$25,000 if 1-10 users
additional of $1,000 for 11-20 users
additional of $750 for 21-40 users
additional of $500 for >40 users.

I have created this formula which doesnt work:

Hope anybody can help me


See More: Nested if function

February 6, 2012 at 08:42:23
We can't tell what columns your example data is in. Please click on the blue line at the end of this post and read the instructions on how to post example data in this forum.

In addition, your formula can't be correct since it starts with an "F" and not an equal sign. I assume that's a typo, but since that's all we see from where we're sitting, that's all we have to go on.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question