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.