IF-then formula doesn't work

[pegman]

I can't figure this one out...

=IF(M16>0,INDIRECT("V"&SUM(O2+1),0))

the INDIRECT("V"&SUM(O2+1) aspect worked fine, but I only wanted that value
to show so I added the IF aspect... I keep getting errors in the value

 

[Teethless mama]

You put a bracket in wrong place
here is the correction:

=IF(M16>0,INDIRECT("V"&SUM(O2+1)),0)

 

[Bob Phillips]

=IF(M16>0,INDIRECT("V"&SUM(O2+1)),0)


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[pegman]

Thanks guys, everything works beuatiful now...

I need to figure how to protect these worksheets NOW...!!!!

 

[David Biddulph]

And you don't need the SUM as well as the + sign.
=IF(M16>0,INDIRECT("V"&(O2+1)),0)

 

[Gord Dibben]

Tools>Protection>Protect Worksheet is the norm.


Gord Dibben MS Excel MVP

 

[T. Valko]

The reason you got an error is because as written:

=IF(M16>0,INDIRECT("V"&SUM(O2+1),0))

Your formula is using the 0 in INDIRECT to denote that you're using R1C1
reference style.

So, Vn is not a legitimate R1C1 reference so you get the error.