When you’re setting up your crop plan, there comes a time when you need to calculate how many seeds you will need to have on hand..

That seems simple, just multiply the number of beds by the number of rows per bed by your seed rate, and voilà!

**#beds x rows/bed x seed rate = number of seeds**

But that only works if you’re dealing with a direct seeded crop.

If you’re starting this crop indoors or in a nursery, then you actually need to start with the number of trays you’re seeding.

That’s a whole other formula.

**#trays x cells/tray x seeds/cell = number of seeds**

If only there was a way for one formula to do both.

You’re in luck.

**There is the IF FORMULA!**

With the IF formula, you can write “**IF** this crop is direct seeded, calculate the seeds needed this way; but **IF** this crop is transplanted, calculate the seeds this other way.”

Once you’ve understood how to set up an IF formula, you’ll see that you can use it all over your spreadsheets!

## In this tip, we’ll see …

- How to use the
**IF formula**to apply different formulas in different situations. - How to
**embed IF formulas in other IF formulas**to get more accurate results. - How to set up your
**Crop Plan**to calculate your seed needs with the IF formula. - How to link your
**Seed Order**to your Crop Plan with a**SUMIF formula**.

You can get the spreadsheet from this tip to follow along at home.

**What do you want to look up in your spreadsheets?**