Removing False Word in Excel
Closed
baren91
Posts
2
Registration date
Wednesday 29 April 2015
Status
Member
Last seen
29 April 2015
-
29 Apr 2015 à 01:37
baren91 Posts 2 Registration date Wednesday 29 April 2015 Status Member Last seen 29 April 2015 - 29 Apr 2015 à 06:42
baren91 Posts 2 Registration date Wednesday 29 April 2015 Status Member Last seen 29 April 2015 - 29 Apr 2015 à 06:42
Related:
- Removing False Word in Excel
- Ms word pdf extension - Download - Other
- How to remove hyperlink in word - Guide
- Full screen in word - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Number to word in excel - Guide
2 responses
MaxStart
Posts
338
Registration date
Tuesday 3 March 2015
Status
Contributor
Last seen
3 July 2015
69
29 Apr 2015 à 05:58
29 Apr 2015 à 05:58
what amount?
until you explain the amount thing start with this
until you explain the amount thing start with this
=IF(O5<0,VALUE(N5),"")&IF(O5>0,VALUE(M5),"")
baren91
Posts
2
Registration date
Wednesday 29 April 2015
Status
Member
Last seen
29 April 2015
29 Apr 2015 à 06:42
29 Apr 2015 à 06:42
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
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
