| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To Stop or Not to Stop | Excel Discussion (Misc queries) | |||
| Stop scrolling | Excel Discussion (Misc queries) | |||
| Breakpoint will not stop Excel subroutine | Excel Discussion (Misc queries) | |||
| what is the keys to stop recording, i cant press it when making a. | Excel Discussion (Misc queries) | |||
| How do I stop other circles in other boxes to stop selecting? | Excel Worksheet Functions | |||
Linear Mode
