Greater by 20% formula

[ExcelNewby]

How can I make the below formula to say not only greater > but greater by 20%?

=IF(ISBLANK(D6),"Blank",IF(D6>VLOOKUP($C6,Sheet1!$ G$5:$L$24,WEEKDAY(NOW() )),"Verify",""))

TIA,

ExcelNewby

[Paul]

Hi ExcelNewby,

Try adding *1.2 to the end of your VLOOKUP (or the start, doesn't matter). Like so:

Please Login or Register  to view this content.

[ExcelNewby]

It works great. Thank you Paul!!