LinkBack URL
About LinkBacks
Simply_Me 
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.
=IF(A2-3.5>0,"+" & A2-3.5,A2-3.5)
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.=IF(A2-3.5>0,"+" & A2-3.5,A2-3.5)
How aboutFormula:
=IF(A2-3.5>0,"+" & TEXT(A2-3.5,"0.00"),A2-3.5)
Try:Formula:=IF(A2-3.5>0,"+" & TEXT(A2-3.5, "0.00"),A2-3.5)
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
Register To Reply
Bookmarks