I cant get rid of the false function

Closed
sc120915 - Apr 5, 2017 at 04:35 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Apr 5, 2017 at 06:04 AM
Hello,

I don't know whats wrong with this formula =IF(C4="Single",K4*1, IF(C4="Twin",K4*2, IF(C4="Quad",K4*4)))

It keeps saying false in the cell

can someone please help!!


Related:

1 response

vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 259
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.
0