Removing False Word in Excel
Closed
baren91
Posts
2
Registration date
Wednesday April 29, 2015
Status
Member
Last seen
April 29, 2015
-
Apr 29, 2015 at 01:37 AM
baren91 Posts 2 Registration date Wednesday April 29, 2015 Status Member Last seen April 29, 2015 - Apr 29, 2015 at 06:42 AM
baren91 Posts 2 Registration date Wednesday April 29, 2015 Status Member Last seen April 29, 2015 - Apr 29, 2015 at 06:42 AM
Related:
- Removing False Word in Excel
- Number to word in excel - Guide
- Word apk for pc - Download - Word processors
- Number to text in word - Guide
- Tick symbol in word - Guide
- Backspace not working in word - Guide
2 responses
MaxStart
Posts
339
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
69
Apr 29, 2015 at 05:58 AM
Apr 29, 2015 at 05:58 AM
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 April 29, 2015
Status
Member
Last seen
April 29, 2015
Apr 29, 2015 at 06:42 AM
Apr 29, 2015 at 06:42 AM
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
