I cant get rid of the false function
Closed
sc120915
-
Apr 5, 2017 at 04:35 AM
vcoolio Posts 1364 Registration date Thursday July 24, 2014 Status Moderator Last seen February 10, 2023 - Apr 5, 2017 at 06:04 AM
vcoolio Posts 1364 Registration date Thursday July 24, 2014 Status Moderator Last seen February 10, 2023 - Apr 5, 2017 at 06:04 AM
Related:
- I cant get rid of the false function
- How to get rid of false in excel ✓ - Office Software Forum
- App to get rid of subscriptions - Guide
- Function of spreadsheet - Guide
- How to get rid of white box on computer screen ✓ - Monitor Forum
- Function key stuck on - Guide
1 reply
vcoolio
Posts
1364
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 10, 2023
252
Apr 5, 2017 at 06:04 AM
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.