LinkBack URL
About LinkBacks
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
Greater by 20% formula
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
Hi ExcelNewby,
Try adding *1.2 to the end of your VLOOKUP (or the start, doesn't matter). Like so:
=IF(ISBLANK(D6),"Blank",IF(D6>VLOOKUP($C6,Sheet1!$G$5:$L$24,WEEKDAY(NOW()))*1.2,"Verify",""))
It works great. Thank you Paul!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks