Error trying to define reference cell

I'm getting an error with the following formula in cell AA14:

=if(Y14<0,if(C(14+D14)<C14,2,1,""))

I want excel to compare cell C59 and C14 (the value in D14
is 45). What is the correct way besides C(14 + D14)?

Thanks,
Mark

So the cell C59 depends on the value of D14, i.e. the row is obtained by the contents of D14 plus 14? If so, you need to do it like this:

=if(Y14<0,if(INDIRECT("C"&(14+D14))<C14,2,1),"")

Hope this helps.

Pete

Perfect. Thanks Pete!

Mark

You're welcome - thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete