I'm trying to set up a formula to do the following. I would like cell E90 to
give a text output. The text is dependent upon 2 other cells in the workbook
(Q88 and T87). I want the text in E90 to say "Full Discount Achieved" if Q88
and T87 reach the highest bucket. Otherwise, if either of cells Q88 or T87
do not have a value in the highest bucket, I want the text output to say "X
amount in Q88 or Y Amount in T87 needed to reach next discount level". There
are 3 buckets for Q88 and 6 buckets for T87. I've tried using the IF
formula, but I don't know how to get the output to show how much is needed to
achieve the next bucket, rather than the full discount.

Sheet 1 contains the buckets and another section of the workbook uses the
VLOOKUP formula to determine which discount level is achieved.

Any help is greatly appreciated. Thanks!