ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   entering formulas (https://www.excelbanter.com/excel-worksheet-functions/81942-entering-formulas.html)

Tara Martin
entering formulas
 
I have entered the formula
=IF((OR(E35="",C35="")),0,IF((E35<C35),((E35-C35)*24)+24,(E35-C35)*24))+IF((OR(I35="",F35="")),0,IF((I35<F35),(( I35-F35)*24)+24,(I35-F35)*24)),
but I cannot figure out how to show my cell blank if there is no information
in it....Please help

Duke Carey
entering formulas
 
What do you mean "show my cell blank if there is no information in it"

By the way, I think that this formula is shorter and clearer like this

=IF((OR(E35="",C35="")),0,(E35-C35)*24+IF(E35<C35,24,0))+IF((OR(I35="",F35="")),0 ,(I35-F35)*24+IF((I35<F35),24,0))


"Tara Martin" wrote:

I have entered the formula
=IF((OR(E35="",C35="")),0,IF((E35<C35),((E35-C35)*24)+24,(E35-C35)*24))+IF((OR(I35="",F35="")),0,IF((I35<F35),(( I35-F35)*24)+24,(I35-F35)*24)),
but I cannot figure out how to show my cell blank if there is no information
in it....Please help


All times are GMT +1. The time now is 04:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com