IF Function

[Guest]

How can I write the following for cell g3:
If f3 is equal to or less than zero return the answer zero. If f3 is greater
than zero then calculate and show the answer to (f3) times (a3 divided by
24).

 

[Guest]

if(f3<=0,0,f3*(a3/24))

 

[Frank Kabel]

Hi
=MAX(0,F3)*(A3/24)