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