IF function

Question

IF function

Anonymous

I am wanting to a function for quarterly goals. Example I want 4 columns Qtr1, Qtr2, Qtr3, Qtr4 and another column that is Units to Goal. Can I make a formula that will update the units to goal for each quarter? If qtr1 and qtr2 have values can i tell what the units to goal is for the most current qtr?

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous

Hi William,

Thank you for the reply.

You can try the following formula to see if it could meet your requirement:

=IF(ISNUMBER(D2),H2-D2,IF(ISNUMBER(C2),H2-C2,IF(ISNUMBER(B2),H2-B2,IF(ISNUMBER(A2),H2-A2))))

If it doesn't work, please feel free to post back.

Best regards,

Jazlyn

0 comments

2 additional answers

Answer 1

This is what I am trying to do. I want to know if it is possible to calculate the units to goal for the current quarter. This example could calculate what is needed for quarter 2, then if there are units in qtr 3 if it would calculate units to goal for that quarter.

Qtr 1 Units	Qtr 2 Units	Unit Goal
163	25	150

Answer 2

Dear William,

Thank you for posting in Microsoft Community.

I understand that you have requirement about IF function to calculate your columns.

Could you please check if this is the one you want.

Used SUM for each QTR to sum up all the values to Units to Goal and use filter.

Calculate values in a PivotTable (microsoft.com)

We look forward to your response. Thanks for your cooperation. Stay safe and healthy always.

Sincerely,

Zee | Microsoft Community Moderator

Share via

IF function

2 additional answers