LinkBack URL
About LinkBacks
J Glanton 
I am using this formula to calculate gain or loss
How can i get a + or - sign to show in my answer.
=IF(B3<B2,B2-B3,IF(B3>B2,B3-B2,""))
example: + $100.00
or - $100.00
Any help is appreciated
Thanks
Joel
I am using this formula to calculate gain or loss
How can i get a + or - sign to show in my answer.
=IF(B3<B2,B2-B3,IF(B3>B2,B3-B2,""))
example: + $100.00
or - $100.00
Any help is appreciated
Thanks
Joel
Last edited by J Glanton; 11-11-2011 at 09:44 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks