If function with Calculation

W

WallyGathor

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

Marcelo

=if(a1>1,a1/a3,"Not required")

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



"WallyGathor" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Avoiding redundant calculations 7
Calculate end date and time 1
copy specific cells from sheets if the information is correct 3
Conditional Formatting - Given dates within certain range of days 4
IF AND question 2
MATH COMPUTAION 6
Need help calculating probabilities 7

Top