Thread: IF Function
View Single Post
  #2   Report Post  
LanceB
 
Posts: n/a
Default
if(f3<=0,0,f3*(a3/24))

"Bill R" wrote:

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).
Reply With QuoteReply With Quote