div error % formula

[Russ At Index]

Morning ,

I have the following formula within a cell that is formatted as %

=1-(AA63/T63)

Until I populate the cells included in the formula I returns div error (as you would expect)

I am at a loss as to how I can "if error" this formula , can someone kindly help me out ?

Thanks

Russ.

 

[AlanY]

so many ways you can do this, try

=if(isblank(AA63),"",1-(AA63/T63))

 

[Russ At Index]

Thanks Alan ,works perfectly .

Have a good weekend

Russ

 

[AlanY]

you're welcome