Removing False Word in Excel

[Closed]
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!
Related:

2 replies

Posts
341
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
68
what amount?
`=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