disc

I have a query: Bron = Excel.CurrentWorkbook(){[Name=""Finost_OI_1""]}[Content]," & Chr(13) & "" & Chr(10) & _ " #""Type gewijzigd"" = Table.TransformColumnTypes(Bron,{{""Date"", type date}, {""ArtNr"", type text}})," & Chr(13) & "" & Chr(10) & _ " #""Rijen gefilterd"" =...

<tbody> Items Per Piece Qty Disc % Apple 10 2 4 Mango 15 3 5 Banana 12 5 2 Orange 18 4 6 Grapes 20 5 4 Pineapple 26 7 2 </tbody> Total Amt without Disc = Total Amt with Disc = how can i get both amounts in 2 different cells. Thanks Amit

The below works: =IF(OR(I10>H10,I11>H11,I12>H12,I13>H13,I14>H14)," Discount Given is greater then Max. Discount", IF(OR(C3={"B","W"}),"Discount can be UP to 7.5 %", IF(OR(C3={"L","N"}),"Disc. Max. 3%/Midwest only - up to 7.5 %", IF(OR(C3={"D","V","X","SR"}),"ENTER xx for MAX...

<colgroup><col width="64" style="width: 48pt; mso-width-source: userset; mso-width-alt: 2340;" span="3"> <col width="77" style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;"> <col width="64" style="width: 48pt; mso-width-source: userset; mso-width-alt: 2340;" span="7"> <col...

I have created a range name Disc and used the formula below for the range name =sum(TB!$F$501:$F$502) The data on sheet "TB" is imported and the rows can change when new data is added I would like to know how to set up my range name formula so that the data pertaining to my range name...

I am trying to lookup a value in a separate workbook whose value contains a forward slash. The lookup value is "Total Disc / Coup" and the lookup doesn't work with the forward slash in it. Here's formula: =VLOOKUP("Total Disc / Coup",'C:\FH276 QB WEEKLY...