Last Non Zero Value In Range

Hi all -

I need to get the right most non zero value from 5 columns (D:H)
So starting at H and working backward
If H5 <> 0 Then C5 = H5
ElseIf G5 <> 0 then C5 = G5
ElseIf F5 <> 0 Then C5 = F5
ElseIf E5 <> 0 Then C5 = E5
ElseIF D5 <> 0 Then C5 = D5

But I'm not sure how to write a formula to achieve this.
Thanks
-marc

Re: Last Non Zero Value In Range

Thanks Tom

Works great!!

Thanks
-marc