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!”
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