Excel formula help required

wrg 11:26 23 Jun 09
Locked

Morning all

I have the following in a spreadsheet.

M N O Q

£ Y/N £

1657 y 1657 FALSE

The formula returning false is =IF(N13="n",M13)
How can I incorporate that if column N has a Y then the value returned is 0 (Zero)

Thanks

wrg

mgmcc 11:51 23 Jun 09

Doesn't adding the "0" to your IF statement do what you require?

=IF(N13="n",M13,0)

If the value in cell N13 is "n", then the content of cell M13 is displayed, otherwise the value displayed is zero.

...or am I missing something more complex?

wrg 11:54 23 Jun 09

mgmcc

Thank you very much. I was adding "else,0" and it was not returning the value. I am not very good at these types of statement and I find excel help confusing but knew someone here would know the answer. Once again thank you very much.

This thread is now locked and can not be replied to.

What is ransomware and how do I protect my PC from WannaCry?

Disney layout supervisor Rob Dressel on the challenges of visualising Moana