Help with IF Formula

[Rick187]

In column K4, I have a value of $40 and In Column M4, IF it contains the word "Yes", then in column N4, I would like it to display double the value of K4. So in this case I would like it to automatically display "$80"

If column M4 contains the word "No" then I would like column N4 to display nothing.

I tried the following formula but it didn't work, any help would be much appreciated.

=IF(M4="Yes",K4*2,"")

Thanks in advance for any support.

 

[Fluff]

In what way didn't it work?

 

[Rick187]

In what way didn't it work?

It just says #VALUE

 

[Candyman8019]

That formula should work...is K4 a number or text?

 

[Rick187]

That formula should work...is K4 a number or text?

Okay looks like I've got it working now. in K4, I had the dollar symbol but I've removed that now and it displays now. Thanks.

 

[Candyman8019]

You can change K4 to the 'currency' format to have it show the dollar sign and still work with the formula

 

[Fluff]

Glad you sorted it & thanks for the feedback.