How to create an "If then" formula in Numbers

Question

Numbers_noob Author

Level 1

4 points

How to create an "If then" formula in Numbers

Hello everyone,

I would appreciate some assistance with a formal I am trying to write please.

I am making a stock take sheet, and would like a simple "Yes" or "No" column for if I need to reorder stock.

As an very simplified example, say I sell widgets ...

I should hold 20 widgets in stock (C2)

I currently only have 10 widgets (D2)

I need to place an order for more widgets when I get down to 12 widgets (E2)

I would like column (F2) to give me a "YES" or "NO" answer as to if I need to order more widgets.

I believe it would be something along the lines of ......

IF (D2) (lesser than or equal to) (E2) "YES"

IF (D2) (greater than) (E2) "NO"

I hope that makes sense!

Thanks for your help

Posted on Feb 23, 2022 5:36 AM

Reply

Answer 1

Top-ranking reply

SGIII

Level 8

37,538 points

Feb 23, 2022 8:47 AM in response to Numbers_noob

Based on your description you could have something like this:

You can read more about the use of the IF, including examples, at Help > Formulas and Functions Help in your menu.

IF - Apple Support

If the reorder threshold, 12, is always in one cell, D2, the you could use the $ anchors by checking Preserve Row and Preserve Column, thus $D$2, if you want to copy the formula into additional cells, instead of repeating the reorder threshold in each row as in the screenshot, something like this:

SG

Reply

Answer 2

6x6

Level 6

19,275 points

Feb 23, 2022 8:04 AM in response to Numbers_noob

In cell F2, use the formula:

= IF(D2 <= E2, "YES", "NO")

Reply