I cant get rid of the false function [Closed]

Report
-
Posts
1278
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 16, 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
1278
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 16, 2021
220
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!