So, what do you want to see in column I - two numbers?

What if D is greater than A?

What if F is greater than C?

Please be more specific.

Pete

On Apr 16, 11:35*pm, Shaun H. in the United States <Shaun H. in the
United wrote:
Good evening:

What is the easiest way to perform the following:

On one side, I have Column A (the quantity actually purchased and ordered),
B (the unit price), C (the total price), and on the other side are Column D
(the estimated quantity needed), E (the estimated unit price), F (the
estimated total price). I already have two additional columns G (a quantity
variance) and H (a total price variance). I am attempting to distinguish the
two in a totally separate column, column I.
In other words, I would like column I to state "If column A is greater than
column D, then Column I should be column F AND/OR if column C is greater than
column F then te price in column F should be reflected. I would like all of
that to be column I. Is there a formula to include both equations?

Thank you very much.