Formula zero return

Closed
laters150 Posts 1 Registration date Saturday August 20, 2016 Status Member Last seen August 20, 2016 - Aug 20, 2016 at 10:43 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 20, 2016 at 12:13 PM
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 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Aug 20, 2016 at 12:13 PM
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
0