How To Stop #Div

[DAI via OfficeKB.com]

Hello,

I have a simple formula (=(L30/H30)*100) which works fine, However I would
like to set up my worksheet to not give an error while "L30 and H30" have no
values yet.

Then i can copy the formula down the column and enter the values when
required.

I know its something simple but I need a little help.

Thank You.

 

[Max]

One way:

=IF(OR(L30="",H30=""),"",(L30/H30)*100)

 

[DAI via OfficeKB.com]

Max,

Thats great,

Thank you

One way:

=IF(OR(L30="",H30=""),"",(L30/H30)*100)

Hello,

[quoted text clipped - 9 lines]

Thank You.

 

[Max]

You're welcome !