Value is 0 like it to be blank

[Steved]

Hello from Steved

Please what is required for the below formula
to have the cell Value 0 to be blank.

=MOD(D8-C8,1)+MOD(F8-E8,1)-G8

Thankyou.

 

[Frank Kabel]

Hi
one ay:
=IF(MOD(D8-C8,1)+MOD(F8-E8,1)-G8,MOD(D8-C8,1)+MOD(F8-E8,1)-G8,"")

or use a custom format like
0,-0,

 

[Rodney POWELL]

Steved -- will it work for you to wrap it in an IF function like this ?

=IF(MOD(D8-C8,1)+MOD(F8-E8,1)-G8=0,"",MOD(D8-C8,1)+MOD(F8-E8,1)-G8)


- Rodney POWELL
Microsoft MVP - Excel

Beyond Technology
Spring, Texas USA
www.BeyondTechnology.com



Hello from Steved

Please what is required for the below formula
to have the cell Value 0 to be blank.

=MOD(D8-C8,1)+MOD(F8-E8,1)-G8

Thankyou.

 

[Steved]

Thankyou Frank.

-----Original Message-----
Hi
one ay:
=IF(MOD(D8-C8,1)+MOD(F8-E8,1)-G8,MOD(D8-C8,1)+MOD(F8- E8,1)-G8,"")

or use a custom format like
0,-0,


--
Regards
Frank Kabel
Frankfurt, Germany


.

 

[Steved]

Thankyou Rodney

and Yes.

-----Original Message-----
Steved -- will it work for you to wrap it in an IF function like this ?

=IF(MOD(D8-C8,1)+MOD(F8-E8,1)-G8=0,"",MOD(D8-C8,1)+MOD (F8-E8,1)-G8)


- Rodney POWELL
Microsoft MVP - Excel

Beyond Technology
Spring, Texas USA
www.BeyondTechnology.com



"Steved" <[email protected]> wrote in

message news:[email protected]...