I cant get rid of the false function

Closed
sc120915 - Apr 5, 2017 at 04:35 AM
vcoolio
Posts
1347
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
June 10, 2022
- 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!!


1 reply

vcoolio
Posts
1347
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
June 10, 2022
249
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