Removing False Word in Excel [Closed]

Report
Posts
2
Registration date
Wednesday April 29, 2015
Status
Member
Last seen
April 29, 2015
-
Posts
2
Registration date
Wednesday April 29, 2015
Status
Member
Last seen
April 29, 2015
-
Hello!
How to remove the false word in this formula and retain only the amount instead?

=IF(O5<0,VALUE(N5))&IF(O5>0,VALUE(M5))

Thanks!

2 replies

Posts
341
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
59
what amount?
until you explain the amount thing start with this
=IF(O5<0,VALUE(N5),"")&IF(O5>0,VALUE(M5),"")

Posts
2
Registration date
Wednesday April 29, 2015
Status
Member
Last seen
April 29, 2015

COLUMN 'P' IS THE RESULT OF THE FORMULA ABOVE, MY QUESTION IS HOW TO REMOVE THE "FALSE" WORD REFLECTED AFTER AND BEFORE THE AMOUNTS AND RETAIN THE VALUES (AMOUNTS).

M N O P
160.00 80.00 (80.00) 80FALSE
96.00 80.00 (16.00) 80FALSE
95.00 80.00 (15.00) 80FALSE
75.00 50.00 (25.00) 50FALSE
75.00 80.00 5.00 FALSE75
75.00 80.00 5.00 FALSE75
100.00 50.00 (50.00) 50FALSE
75.00 80.00 5.00 FALSE75
72.00 80.00 8.00 FALSE72