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

I need formulae on adding figures IF paid = the amt adds to +Cash at Bank SCB, IF unpaid = the amt adds to + Accure Expenses

Solved by T. H. in 11 mins

i need to find the % of 2 different figures in a pivot table. so basically column 2 divided by column 1 inside a pivot table, however when i do that by adding a field..it's confusing excel. Help?

Solved by B. Q. in 29 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

Hi, how do i get excel not to add up the minus numbers in an overall total? So i have got 12 total figures at the bottom, some of which are positive and some negative but its adding up the negatives and not taking them off. Thank you

Solved by K. A. in 11 mins

sir, how to find age calculator age on date formula

Solved by A. A. in 22 mins