How To Stop #Div
 

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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200611/1

How To Stop #Div
 

One way:

=IF(OR(L30="",H30=""),"",(L30/H30)*100)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DAI via OfficeKB.com" <u29573@uwe wrote in message
news:69e8fc131a981@uwe...
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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200611/1

How To Stop #Div
 

Max,

Thats great,

Thank you


Max wrote:
One way:

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

[quoted text clipped - 9 lines]

Thank You.

--
Message posted via http://www.officekb.com

How To Stop #Div
 

You're welcome !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DAI via OfficeKB.com" <u29573@uwe wrote in message
news:69e93f3ff9d87@uwe...
Max,

Thats great,

Thank you