ExcelBanter - If function with Calculation

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

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

- - If function with Calculation (https://www.excelbanter.com/excel-worksheet-functions/231583-if-function-calculation.html)

WallyGathor

If function with Calculation

Result I need to see in A2
If A1 1 then A3 / A1 but if A1<=1 "Not required"

I have tried a few things with the IF function without success.

Thank you for your help.
--
WG

Eduardo

If function with Calculation

=if(A11,A3/A,"Not Required")

If this was helpful please click yes, thanks

"WallyGathor" wrote:

Result I need to see in A2
If A1 1 then A3 / A1 but if A1<=1 "Not required"

I have tried a few things with the IF function without success.

Thank you for your help.
--
WG

Eduardo

If function with Calculation

OOpps I miss a cell reference

=if(A11,A3/A1,"Not Required")

"Eduardo" wrote:

=if(A11,A3/A,"Not Required")

If this was helpful please click yes, thanks

"WallyGathor" wrote:

Result I need to see in A2
If A1 1 then A3 / A1 but if A1<=1 "Not required"

I have tried a few things with the IF function without success.

Thank you for your help.
--
WG

Marcelo

If function with Calculation

=if(a11,a1/a3,"Not required")

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo

"WallyGathor" escreveu:

Result I need to see in A2
If A1 1 then A3 / A1 but if A1<=1 "Not required"

I have tried a few things with the IF function without success.

Thank you for your help.
--
WG

All times are GMT +1. The time now is 03:00 PM.