Excel formula help required

  wrg 11:26 23 Jun 2009
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 2009

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 2009

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.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

The secrets of creating gory VFX

How to update iOS on iPhone or iPad

WhatsApp : comment lire vos messages sans que l’expéditeur le sache