Do i need macros or multiple IF?

[saturos]

Hey guys

Lets say in excel, i have one number A
and another number B.

The calculation is change, so A/B-100 (percentage change between A and B)

IFERROR, return "-"
So, IF
(A/B-100)^2 less than 0.01, return <1%
else IF
(A/B-100) more than 1, return >100%
else IF
(A/B-100) less than 1, "not meaningful"
if all above false,
return (A/B-100)


is there a simple way to do this? basically, what it means is first, you calculate the difference of say, $3.00 and $4.00

if its more than 100% (more than double), the cell gives ">100%"
if its so small, the cell gives "<1%"
if the change is from negative to positive, the cell gives "n.m"
other wise, just give the percentage change ($4/$3-1)

and iferror (one of the dollars is 0 or no data), give a "-"

is there a simple way to do this?

[martindwilson]

A/B-100 ? shouldn't that be A/B-1

[saturos]

sorry T_T its -1. not -100.

actually its (A/B-1) * 100