I cant get rid of the false function
Closed
sc120915
-
Apr 5, 2017 at 04:35 AM
vcoolio
vcoolio
- Posts
- 1347
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- June 10, 2022
Related:
- I cant get rid of the false function
- How to get rid of false in excel ✓ - Forum - Office Software
- Removing False Value ✓ - Forum - Excel
- Removing "FALSE" from an IF statement with a VLOOKUP ✓ - Forum - Excel
- Need help to remove FALSE from cell ✓ - Forum - Office Software
- Word "False" kept on Appearing? =IF function ✓ - Forum - Excel
1 reply
vcoolio
Apr 5, 2017 at 06:04 AM
- Posts
- 1347
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- June 10, 2022
Apr 5, 2017 at 06:04 AM
Hello SC,
A minor alteration to the formula should do the trick:-
=IF(C4="Single",K4*1, IF(C4="Twin",K4*2, IF(C4="Quad",K4*4,"")))
Cheerio,
vcoolio.
A minor alteration to the formula should do the trick:-
=IF(C4="Single",K4*1, IF(C4="Twin",K4*2, IF(C4="Quad",K4*4,"")))
Cheerio,
vcoolio.