Formula zero return

[Closed]
Report
Posts
1
Registration date
Saturday August 20, 2016
Status
Member
Last seen
August 20, 2016
-
Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
-
Hello ~

How can I get a zero return instead of a FALSE statement with the following formula?

=IF(F4>E4,(F4-E4)*24,IF(F4<E4,24+((F4-E4)*24)))

Expert advice is appreciated.

Thank you.

1 reply

Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
145
laters150, Good morning.

Try to use:

=IF(F4>E4,(F4-E4)*24,IF(F4<E4,24+((F4-E4)*24), 0 ))

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão