Jason has attended:
Excel Advanced course
Excel Intermediate course
Excel Advanced course
Excel Advanced - Formulas & Functions course
Excel Advanced - Formulas & Functions course
Unrealistic percentage values
I'm preparing data analysis of gross margins and want to avoid unrealistic values, eg anything over 500% positive and negative.
So far i have the following:
=-IFERROR(I37/H37,0).
can anyone please assist.
regards
Jason
RE: Unrealistic percentage values
Hi Jason
Interesting question. How about this formula in a separate cell (eg C37)
=IF(OR(I37/H37>500%,I37/H37<-500%),"0",I37/H37)
It dispays the correct gross margin unless it is greater than 500% or less than -500%.
Best to format C37 to % format.
If you want to display a blank for the extreme gross marginsv then change "0" to "" in the formula.
Does that do what want?
Doug
Best STL
