I cant get rid of the false function

[Closed]
Report
-
Posts
1320
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
October 8, 2021
-
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

Posts
1320
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
October 8, 2021
239
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.