% Change Between 2 Yrs with Iferror formula

[msvoboda27]

Hello
I was hoping someone could please help with formula that I can't seem too get.
I am doing a simple % change formula, if there is no value in column P/row 99 the cell in R99 shows blank. If have no value in column Q/row 100 the formula calculates with "-100%"
I wanted the formula to also show blank if cell Q/row 100 is blank. It escapes me how to do this. Can some please reeducate me.
Many thanks in advance!
Michael

 

[JimM]

=IF(OR(P98="",P99=""),"",(Q98-P98)/P98)

 

[msvoboda27]

=IF(OR(P98="",P99=""),"",(Q98-P98)/P98)

Thank you JimM for your time and support. I was not that close!
Best, Michael

 

[msvoboda27]

The solution above doesn't seem to work since it's using values on two different rows. I apologize I should have been more clear.
I like to make it for a % change formulas if one of the values either p98 or q98 is blank then the formula result cell would also be blank.
I tried "IF(OR(Q98=" ",P98=" "), " " ,(Q98-P98/P98)
Value p98 blank get "#Div/0!"

value q98 blank blank get "-100.0%"

 

[JimM]

Sorry my bad!

You've got the right idea but you don't want any spaces between the ""s


=IF(OR(P98="",Q98=""),"",(Q98-P98)/P98)

 

[msvoboda27]

Perfect!
Thanks again