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

Hello
I am trying to input a formula to compute a mortgage monthly payment in excel

Solved by I. W. in 21 mins

I need help to create an excel calculator formula for settlement payment

Solved by F. W. in 30 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

I have a formula =C3/B3 which is 82/123 excel is calculating it to be 66.8% On my calculator it is 66.6% C4/B4 which is 39/36 is 106.9% on excel, but 108.3% on my calculator. What am I doing wrong? Automatic is checked under calculation options.

Solved by E. F. in 25 mins

How do you get the same result on a standard calculator and an excel formula?
=(G545/$B$3*$B$5+(G545/$B$3*$B$7))*(1-$B$6)
This is my formula but I don't receive the same result on my calculator?

Solved by S. E. in 18 mins