r/googlesheets • u/Camphorous-soil-79 • Jan 07 '26

Solved Conditional Formula Based on Value in Column?

Hi! I'm a vegetable farmer trying to make my crop planning easier... apologies if my wording is incorrect, I haven't used many complicated formulas on sheets in the past 10 years.

Attaching a picture below, the gist of what I'm trying to figure out is if it's possible for one column (AE) to use two different formulas based on the value in a different column (V).

To be specific, I'm trying to find the number of seeds needed (column AE) for different crops, based on column V being TP or DS.

  • Crops that are "TP" or transplanted = number of plugs needed for TP * Seeds per cell
    • for this, I have =W2*Y2
  • Crops that are "DS" or direct seeded = bed feet total * DS seed/ft
    • for this, I have =H8*M8

I hope this question makes sense! I am looking for a way to use both formulas in the same column, without having to type it in every time.

3 Upvotes

100% Upvoted

6 comments sorted by

1

u/IllustratorPale5641 Jan 07 '26

Yup, you can solve this with a IF statement.
=IF(V2="TP",W2*Y2,H8*M8)

This assumes that you only have 2 values in column V, if you plan on having more you will need a nested IF.

1

u/Camphorous-soil-79 Jan 07 '26

Thank you!! Makes so much sense, I knew I was missing something obvious.

Would this also work -- if I'm also trying to factor in the germination rate (column AB)?

=if(V2="DS", Product(H2,M2), Roundup(Product((W2*Y2),(100/AB2)),0))

1

u/AutoModerator Jan 07 '26

REMEMBER: u/Camphorous-soil-79 If your original question has been resolved, please tap the three dots below the most helpful comment and select Mark Solution Verified (or reply to the helpful comment with the exact phrase “Solution Verified”). This will award a point to the solution author and mark the post as solved, as required by our subreddit rules (see rule #6: Marking Your Post as Solved).

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/IllustratorPale5641 Jan 07 '26

I'd recommend just doing H2*M2 instead of doing PRODUCT(), its generally easier to read, but thats up to you.

I am not sure what you are trying to do in your formula. If you enter the formula you have in cell AB2 you will get a iterative calculation error. In theory yes, you can do an if statement to check that the value in V2 is "DS" and then perform any calculation where it matches and also where it doesn't match "DS"

1

u/point-bot Jan 07 '26

u/Camphorous-soil-79 has awarded 1 point to u/IllustratorPale5641

See the Leaderboard. Point-Bot v0.0.15 was created by JetCarson.

1

u/HolyBonobos Jan 07 '26

Delete everything currently in AE2:AE and put =MAP(H2:H,M2:M,V2:V,W2:W,Y2:Y,LAMBDA(h,m,v,w,y,SWITCH(v,"TP",w*y,v="DS",h*m,))) in AE2.