#DIV/0! problem

[puiuluipui]

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]

Try
=IF(COUNT(E43:E44)=2,(E44/E43)*100,"No Entry")

If this post helps click Yes

 

[Eduardo]

Hi,
=if(or(E44="",E43=""),"Cell Empty",(E44/E43)*100)

 

[puiuluipui]

It's working!
Thanks!

"Eduardo" a scris:

Hi,
=if(or(E44="",E43=""),"Cell Empty",(E44/E43)*100)

 

[puiuluipui]

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