I cant get rid of the false function

Question

I cant get rid of the false function

[Closed]

Report

sc120915 - Apr 5, 2017 at 04:35 AM
vcoolio

Posts: 1320
Registration date: Thursday July 24, 2014
Status: Moderator
Last seen: October 8, 2021

- 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!!

I cant get rid of the false function
How to get rid of false in excel ✓ - Forum - Office Software
Removing False Value ✓ - Forum - Excel
Removing "FALSE" from an IF statement with a VLOOKUP ✓ - Forum - Excel
Need help to remove FALSE from cell ✓ - Forum - Office Software
Word "False" kept on Appearing? =IF function ✓ - Forum - Excel

1 reply

Ask a question

vcoolio · Answer 1 · 2017-04-05T06:04:11-0400

Answer 1 / 1

vcoolio

Posts: 1320
Registration date: Thursday July 24, 2014
Status: Moderator
Last seen: October 8, 2021

239
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.

I cant get rid of the false function

1 reply

Your reply

Subscribe To Our Newsletter!