I started with a bunch of "if then" functions and after working with excel for a while, I got it down to what is below, with excel adding the asterisk that is after the 20.

=IF(AND(G7<=20*(OR(E7={1,2,3,4,5,6,7,9,10,11,12,15 ,18,19,20,21,22,23,24,27,31}))),ROUNDUP(M7/48,0)*2*G7*D7,)

My questions are:

1. If anyone knows a better formula that has the (G7<=20) paired with E7 having a value of one of the numbers listed above, please share.



2. What is the asterisk doing. The formula above works, but I do not understand how. Excel added the asterisk and I tried looking up the different functions of asterisk, but I couldn't find a good answer.

Thank you for your time!