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 fr...
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))