Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-30-2016, 03:33 PM
pcrjyh12 pcrjyh12 is offline Understanding Asterisk in IF functions Windows 10 Understanding Asterisk in IF functions Office 2016
Novice
Understanding Asterisk in IF functions
 
Join Date: Nov 2016
Posts: 2
pcrjyh12 is on a distinguished road
Default 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!
Reply With Quote
  #2  
Old 11-30-2016, 10:27 PM
xor xor is offline Understanding Asterisk in IF functions Windows 10 Understanding Asterisk in IF functions Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

The asterisk is the symbol for multiplication.
Attached Files
File Type: xlsx Asterisk.xlsx (11.5 KB, 7 views)
Reply With Quote
  #3  
Old 12-01-2016, 03:25 AM
xor xor is offline Understanding Asterisk in IF functions Windows 10 Understanding Asterisk in IF functions Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

A bit more explanation which might be of help.
Attached Files
File Type: xlsx Asterisk_2.xlsx (12.8 KB, 17 views)
Reply With Quote
  #4  
Old 12-01-2016, 07:54 AM
pcrjyh12 pcrjyh12 is offline Understanding Asterisk in IF functions Windows 10 Understanding Asterisk in IF functions Office 2016
Novice
Understanding Asterisk in IF functions
 
Join Date: Nov 2016
Posts: 2
pcrjyh12 is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Understanding Asterisk in IF functions Understanding SmartArt muna Word 1 10-27-2015 06:39 PM
Understanding Asterisk in IF functions Understanding Document Corruption Lagrange Word 3 08-03-2015 11:06 AM
Understanding Asterisk in IF functions 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:32 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft