formula wording

C

cutsygurl

i dont know if you can do this.....
if(c5=10, take the cell 5 right 3 down to it, 0)
if you can, i dont know how to write it in excel language
thanks if anyone can hel
 
B

BenjieLop

cutsygurl said:
i dont know if you can do this.....
if(c5=10, take the cell 5 right 3 down to it, 0)
if you can, i dont know how to write it in excel language
thanks if anyone can help
Click to expand...

Try this ...

=if(C5=10,offset(C5,3,5),0
 
Top