|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 29th, 2009, 01:34 PM
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
September 29th, 2009, 01:44 PM
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
September 29th, 2009, 01:44 PM
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
September 29th, 2009, 02:20 PM
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
September 29th, 2009, 02:20 PM
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!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
