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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks