Solved for excel calc - need determine max and return amount

January 15, 2017 at 15:59:20
Specs: Windows 7
i need to determine a if (f2+H2)/E2 is greater than 8%, need to return the % at max of 8%
then will need to mult the % in J2 by E2

See More: for excel calc - need determine max and return amount

Report •

#1
January 16, 2017 at 06:54:09
✔ Best Answer
re: "i need to determine a if (f2+H2)/E2 is greater than 8%, need to return the % at max of 8%"

I'm pretty sure this will get you what you are looking for:

=IF((F2+H2)/E2>0.08,0.08,(F2+H2)/E2)

However, if E2 does not have a value in it, you will get a #DIV/0 error. To solve that problem, use this formula which will return a blank cell id E2 is empty:

=IF(E2<>0,IF((F2+H2)/E2>0.08,0.08,(F2+H2)/E2),"")

re: "then will need to mult the % in J2 by E2"

Are we to assume that the formula that you requested is being placed in J2? There is no way for us to know that. Assuming that is the case, simply add *E2 after either of the formulas above.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question