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!

The asterisk is the symbol for multiplication.

Attached Files

Asterisk.xlsx (11.5 KB, 9 views)

A bit more explanation which might be of help.

Attached Files

Asterisk_2.xlsx (12.8 KB, 19 views)

Xor,

This helps out a lot. This was my first time posting on a forum, and this was exactly what I was hoping would happen. I definitely have a better understanding of my function and I had not come across the Name Manager yet, so that is another area of Excel to explore.

I appreciate your time.