Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 

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 06:07 PM.


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