Get instant live expert help on I need help with data table calculator

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I currently have this Formula : =IF(C12<=500,VLOOKUP(C6,'Table 1'!B5:G35,3,FALSE)*Calculator!C12+250,IF(AND(C12>=501,C12<1001),VLOOKUP(C6,'Table 1'!B5:G35,4,FALSE)*Calculator!C12+250,IF(C12>=1001,VLOOKUP(C6,'Table 1'!B5:G35,5,FALSE)*Calculator!C12+250))) I wish to have it if C6 is Norway +170 and if it is switzerland + 100.
Solved by G. U. in 30 mins
I need to make a Formula with Nested IFs, currently i have =IF(C12<=500,VLOOKUP(C6,'Table 1'!B5:G35,3,FALSE)*Calculator!C12+250,IF(C12>=501<=1000,VLOOKUP(C6,'Table 1'!B5:G35,4,FALSE)*Calculator!C12+250,IF(C12>1001,VLOOKUP(C6,'Table 1'!B5:G35,3,FALSE)*Calculator!C12+250))) The part that isnt working is the C12>=501<=1000 and im not sure why!
Solved by C. W. in 18 mins
I Need to create a calculator using a data page. To automatically calculate for customers
Solved by B. Q. in 30 mins
i want to return a result in a cell based a table. i am trying to make a paycheck calculator and can't remember how i got it work. it seems i used vlookup, but i don't recall using table
Solved by C. C. in 25 mins
I have created a formula with true and false however would like it to be $0 if the cells are blank. =IF(AND(OR('BT Calculator'!C4="Super/Pension",'BT Calculator'!C4="IDPS"),'BT Calculator'!D4-'BT Calculator'!E4=0),180,540)
Solved by O. E. in 12 mins