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

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