ExcelBanter - IF Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF Function (https://www.excelbanter.com/excel-worksheet-functions/6956-if-function.html)

Bill R

IF Function

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).

LanceB

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).

Frank Kabel

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Bill R" <Bill schrieb im Newsbeitrag
...
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).

All times are GMT +1. The time now is 01:14 PM.