Here are some problems that our users have asked and received explanations on
I need help to create an excel calculator formula for settlement payment
Solved by F. W. in 30 mins
7. There is a scholarship available to female band members who maintain a sufficient GPA. Add a column to the table named Womens Scholarship. Create a formula to determine the scholarship that female band members will receive based on their GPA. Use the reference table with the defined name of WomensScholarship, which shows the scholarship amount based on GPA. You must use the IF function and the VLOOKUP function and you must use the defined name of the reference table. (Hint: this table shows GPA threshold cut-off values.)
Solved by Z. W. in 14 mins
What is the association between GPA and running away?
Solved by T. B. in 26 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.