formula wording

  • Thread starter Thread starter cutsygurl
  • Start date Start date
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
 
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

Try this ...

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