IF, AND, OR - Looking for Round Apples
More practice with the IF, AND, OR logic formula. I used the IF and OR to identify certain colored apples and mark an x if so. I used the IF & AND to determine if it is a round apple or not.
GETPIVOTDATA
GETPIVOTDATA The GETPIVOTDATA function returns visible data from a PivotTable. Honestly, at its simplest, just use "=" and then click on a cell and then the whole syntax will autopopulate. That is how I returned the Billing Gross, Net, and Commission YTD. I think is helpful to use a data validation list. First, use "=" and reference a cell and then just change the item to reference the cell that has data validation. For example, there when you change the media type on the green cell F12, you can get its unbilled gross, net, and commission. Note that the data validation list dropdown may not appear unless you open the workbook on your Excel Desktop and open the workbook in Edit mode.
Comments
Post a Comment