IF-then formula doesn't work

P

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
 
T

Teethless mama

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

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

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)
 
P

pegman

Thanks guys, everything works beuatiful now...

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

David Biddulph

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

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.
 
Top