| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#DIV/0! problem
Hi, i have this formula:
=(E44/E43)*100 I need the formula to return a message if one or both cells are empty (E44 and E43) The mesage to be No entry. Can this be done? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#DIV/0! problem
Hi,
=if(or(E44="",E43=""),"Cell Empty",(E44/E43)*100) "puiuluipui" wrote: Hi, i have this formula: =(E44/E43)*100 I need the formula to return a message if one or both cells are empty (E44 and E43) The mesage to be No entry. Can this be done? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#DIV/0! problem
Try
=IF(COUNT(E43:E44)=2,(E44/E43)*100,"No Entry") If this post helps click Yes --------------- Jacob Skaria "puiuluipui" wrote: Hi, i have this formula: =(E44/E43)*100 I need the formula to return a message if one or both cells are empty (E44 and E43) The mesage to be No entry. Can this be done? Thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#DIV/0! problem
It's working!
Thanks! "Eduardo" a scris: Hi, =if(or(E44="",E43=""),"Cell Empty",(E44/E43)*100) "puiuluipui" wrote: Hi, i have this formula: =(E44/E43)*100 I need the formula to return a message if one or both cells are empty (E44 and E43) The mesage to be No entry. Can this be done? Thanks! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#DIV/0! problem
It's working!
Thanks! "Jacob Skaria" a scris: Try =IF(COUNT(E43:E44)=2,(E44/E43)*100,"No Entry") If this post helps click Yes --------------- Jacob Skaria "puiuluipui" wrote: Hi, i have this formula: =(E44/E43)*100 I need the formula to return a message if one or both cells are empty (E44 and E43) The mesage to be No entry. Can this be done? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 Sum Problem | Excel Worksheet Functions | |||
| Can anyone see a problem with this? | Excel Worksheet Functions | |||
| Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
| IF and LEN and MID Problem | Excel Worksheet Functions | |||
| problem with a conditional max problem | Excel Discussion (Misc queries) | |||
Linear Mode
