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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Prehistoric Britain is laid out in these Royal Mail stamp illustrations

Best running headphones | Best sport & fitness headphones: 4 brilliant pairs of wireless…