Hi guys - hope all are well.
Think i may be being a bit thick here but,,, i need to display a percentage gap.
Sometimes the resulting calculation value displays as -1.2% for example, in which case i would then have to reverse the numerator and denominator.
is there another way to avoid the minus? as i only want the difference and not the minus sign?
Thanks alot for any help.
Last edited by Blake 7; 02-03-2011 at 08:12 AM.
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
Do you mean ABS ?
=ABS(calculation)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Hi Donk - im afraid you have lost me........ ABS?
I'll attach a woorkbook
The calc is in D, E and F6 but i'll have a column full
Last edited by Blake 7; 02-03-2011 at 08:09 AM.
ahhhhhhhhhhh yes =ABS!!! did it!! thanks don - absolute
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks