Here are some problems that our users have asked and received explanations on
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