use
=RIGHT(A1,8)*-1
or to always return positive values
=ABS(RIGHT(A1,8))
use
=RIGHT(A1,8)*-1
or to always return positive values
=ABS(RIGHT(A1,8))
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks