# Nested if function

February 6, 2012 at 03:54:07
Specs: Windows XP
 Hi I want to create a price calculator that looks like: B C J4 250005 No of users 5 10006 Total Price (formula here) 7507 500This is the price:\$25,000 if 1-10 usersadditional of \$1,000 for 11-20 usersadditional of \$750 for 21-40 usersadditional of \$500 for >40 users.I have created this formula which doesnt work:F(AND(C5>0,C5<=10),J4,IF(AND(C5>10,C5<=20),J4+(C5*J5),IF(AND(C5>20,C5<=40),J4+(C5*J6),IF(AND(C5>40,J4+(C5*J7))))))Hope anybody can help meCheers

See More: Nested if function

#1
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