typing in formula help

[cutsygurl]

is it possible to do this
if(c5=10, take the cell 5 right 3 down to it, 0)
i dont know how to write that in excel language
thanks a bunch if anyone can hel

 

[Guest]

Hi,
Try
=IF(C5=10,OFFSET(C5,5,3),0)

 

[merlin]

is it possible to do this
if(c5=10, take the cell 5 right 3 down to it, 0)
i dont know how to write that in excel language
thanks a bunch if anyone can help

if(c5=10,H8,0)