If formula isn't working

**ampielee** · 02-18-2010, 06:25 AM

Hello all, I'm really going crazy

(im already anyhow)
To be honest Im pretty ok with excel but this time my brain doesnt want to move in order to get my own solution.
So this is the case:

I have 3 columns. 1 is called amount payed in 2009
the other is called amount payed in 2010.
And the 3rd is for me to state if the amount has been paid. (I will use the word "yes")
Now I wanted to use an if formula to say that if the 3rd column contains the word yes it should look which of the 1st 2 columns contains an amount (per line there will only be one amount in those cells, so or in 2009 or 2010) and take that amount. But somehow I cannot create the formula. Does anybody knows a formula which I can use to solve this issue?
Pretty please
Thanks a million

**ampielee** · 02-18-2010, 07:43 AM

Hi Teylyn,

Thanks a lot for your message. I did read the Forum rules, but obviously it didnt stcik that well.
Sorry for that and thanks for pointing out.

Ampielee

**teylyn** · 02-18-2010, 07:47 AM

Thanks for changing the title, ampielee.

You could try a formula along the lines of

=IF(C1="yes",sum(A1:B1),"")

or

=IF(C1="yes",max(A1:B1),"")

Adjust the cell references to suit your actual cells. This formula will of course only work if only either A or B contains a number.

hth