ExcelBanter - #DIV/0! problem

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - #DIV/0! problem (https://www.excelbanter.com/excel-discussion-misc-queries/244013-div-0-problem.html)

puiuluipui

#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!

Eduardo

#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!

Jacob Skaria

#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!

puiuluipui

#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!

puiuluipui

#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!

All times are GMT +1. The time now is 03:16 AM.