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

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

*E2after either of the formulas above.

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

Ask Your Question

Weekly Poll

How long do you think until flying cars or taxis are common?

Discuss in The Lounge

Poll History