#1
|
|||
|
|||
Understanding Asterisk in IF functions
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! |
#2
|
|||
|
|||
The asterisk is the symbol for multiplication.
|
#3
|
|||
|
|||
A bit more explanation which might be of help.
|
#4
|
|||
|
|||
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Understanding SmartArt | muna | Word | 1 | 10-27-2015 06:39 PM |
Understanding Document Corruption | Lagrange | Word | 3 | 08-03-2015 11:06 AM |
Not understanding discrepancies in homework and need help | toasty | Project | 1 | 07-21-2015 01:06 PM |
need help understanding mailmerge code | lhuffst | Mail Merge | 1 | 02-13-2013 05:19 PM |
Footnote Sequence, with asterisk, dagger, double dagger | DBinSJ | Word | 3 | 01-02-2012 07:48 PM |