% Value showing neg & pos numbers plus copy down

[admiral70]

Found this solution =max(0,1-($h$38/h29)) had a couple of questions I hope someone can give suggestions.

Can you use this formula without the 0 to show positive and negative #'s?

Then how in the world can you copy this formula down the sheet and have the 38 update down?

Thank you

[NBVC]

I think:

=1-H38/H29

copied down