I am trying to subtract "3.50" from cell A2. if the result is positive value then a (+) sign will be appended to the result (like +0.50).
I tried this formulabut the result does not show the decimal place.
Please Login or Register to view this content.
How aboutFormula:
Please Login or Register to view this content.
Try:Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
You could just give the cell a custom number format of:
+0.00;-0.00
so that it is still an actual number.
Everyone who confuses correlation and causation ends up dead.
Thank you to both of you sir Fluff13 and TMS. Works great.
You're welcome & thanks for the feedback
You're welcome.
Rory's solution is better, IMO.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks