I have two cells both of which have this formula in them
=IF(ISERROR(100%-E18)," ",ABS(100%-E18))
The sells are named percentage drop and percentage increase, I want it so if the percentage is over 100% percentage increase says for example 5% and percentage drop is left blank. Likewise if the percentage is under 100% the cell percentage drop will be for example 5% and the other cell will be left blank.
Help please!
Thanks