Forum Discussion
Creating an if then rule with multiple options
Hi Everyone! I am very novice in excel and trying to populate a field. I'm looking for a way to create a formula for the green column.
I'd like it to populate one of the qtrly rewards from the table below. If they meet either of the minimum thresholds from the 1st or 2nd column below in the yellow cells above!
Let me know what other information is needed, thanks in advance!
3 Replies
With the # of travel days in B2 and the # of full weekends traveled in B3.
Option 1, without a lookup table:
=MAX(QUOTIENT(B2,20),QUOTIENT(B3,3))*1000
Option 2, with the lookup table in G3:I7.
=MAX(VLOOKUP(B2,$G$3:$I$7,3),VLOOKUP(B3,$H$3:$I$7,2))
HansVogelaar Thanks so much for the help!!
Here's the formula I entered, including the column numbers- i tested to see if it would go through and it didn't.. Do you know what I did wrong?
data source (sheet 2)
Enter 0 in A7 and B7 on Sheet2, and change the formula to
=MAX(VLOOKUP(I4,Sheet2!A7:C11,3),VLOOKUP(I5,Sheet2!B7:B11,2))
