Trying input values into one out of four cells based on another cell

mtetzlaf

Below is my formula, which produces the number entered in the [Annual local / Monthly Cost / Cost] column. The problem is, I have the same formula across four columns and only want it to populate in one of the four columns. The formula is based off of number of days in a quarter, which is calculated in column [Q2 - days] (if a start date of services is past the Quarter end date then the number of days in that quarter is 0), so if [Q1 - Days] is 0, the value in the respective Q1 cell is 0 but all the others (Q2 - Q4) are populated with the value in the [Annual Local / Monthly Cost / Cost] column. So, in essence, I need the value to only populate if the start date is within the Quarter.

IF(OR([Spend Bucket]6 = "Discretionary / Other", [Spend Bucket]6 = "WPR / IT"), IF([Q2 - days]6 = 0, 0, [Annual Local / Monthly Cost / Cost]6))

Seeking any advice here please!

Andrée Starå

Hi @mtetzlaf

I hope you're well and safe!

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

mtetzlaf

Sure, here is screenshots of the entire sheet.