Including ROUND and ISBLANK functions to existing formulas

[Phrick]

Back again! Really appreciate the help I received last time.

For my next question....trying to add additional functions to existing formulas which I hope is possible!

1.
=CONCATENATE(" ", IF(E12<E13,"lower","higher"), " by ", ABS(E13-E12), " % ")

This is to try and convert the results into readable text to be extracted into another document. Formula generally works fine however is producing figures of '0.2000000000001' in relation to the ABS function, which obviously is inconvenient; I ideally would just like '0.20', for example. From my googling I think I need the ROUND function included in this to get it down to two decimal places but can't get it to work. Does the ROUND function conflict with the ABS function? The ABS function is necessary however due to me wanting to avoid minus figures.

2.
I'm using many different formulas which this requirement can be applied to but using the above formula:
=CONCATENATE(" ", IF(E12<E13,"lower","higher"), " by ", ABS(E13-E12), " % ")

How would I add a condition where if one of the values (i.e. E12/E13) were blank or zero, the overall result would return N/A? I've tried using ISBLANK but again with no success.
'
So with the above formula, I'm really after a solution that a) produces figures to two decimal places and b) if one of the values is blank, it returns 'N/A'.

Been struggling with this for a while now and not sure where to go (don't you hate when there's plenty on google on the subject but nothing matches your exact requirement! haha)

Cheers excellions!!

Rick

[Jonmo1]

Yes, you can use ROUND with ABS..
=CONCATENATE(" ", IF(E12<E13,"lower","higher"), " by ", ABS(ROUND(E13-E12,2)), " % ")

Then to test for blank/zero try

=IF(OR(E12=0,E13=0),"N/A",CONCATENATE(" ", IF(E12<E13,"lower","higher"), " by ", ABS(ROUND(E13-E12,2)), " % "))

[Phrick]

You made it look so simple!! Haha makes me feel like an idiot for how long I was scratching my head over these.

Both worked perfectly. I was just using the ROUND function incorrectly and overcomplicating the 'N/A' part.

What would I do without you guys!!!!

Thanks Jonmo, much appreciated.

Regards

Rick

[Jonmo1]

Glad to help, thanks for the feedback.