Here are some problems that our users have asked and received explanations on
Created a trend curve for some data; Excel shows the equation as 2E + 06^X^(-1.331). However, when I plot it in a graphing calculator, it does not match the curve drawn in the excel chart.
Solved by F. Y. in 12 mins
I'm trying to do an equation but I got #VALUE!
Solved by M. A. in 17 mins
Hi! I need help with a complex "if" formula for cell C15 of the attached file using absolute value calculator:
If the absolute value of C3 is less than or equal to 100, then C3*(45/100)
If the absolute value of C3 is between 100.001 and 1000, then C3*(45/500)
If the absolute value of C3 is greater than 1000, then 90
Solved by F. L. in 14 mins
I need to find the fit line equation for a graph. I was able to get the r squared value but I need the actual equation to finish my lab
Solved by I. H. in 24 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)