Get instant live expert help on I need help with calculator with remainders

“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 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
I need to build a price calculator with the unit price dependat on volume.
Solved by G. C. in 18 mins
I need help with a over time calculator. I have the template ready just need the formula...
Solved by G. Q. in 29 mins
Hi - I need some help with formulas for simple calculator to work dates dependent on inputs. Hope you can help!
Solved by S. H. 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