Gracias por compartir la tabla. En la celda F6 escribe la siguiente formula: =SI(O(C6>=4;(C6*D6)>=20);(E6*(1-$H$1));"Descuento no aplicable") Después, arrastra hasta la última fila de tu rango para autocompletar. Por favor, confirma que esto funciona. Si crees que es una ...
=LAMBDA(nbC,nbR,LET(Tab,MAKEARRAY(nbR,nbC,LAMBDA(r,c,c&"-"&r)),IFERROR(CHOOSECOLS(Tab,2)/0,Tab)))(6,1)Result=> 1-1 2-1 3-1... In my real formula, in the event of an error I would like to return the entire table as in formula 2. But with this formula Excel st...
Hi Team, I need help building a logic in excel, here’s what I’m trying to do: I have two tabs in excel, sheet 1 and the other is sales tab, In sheet 1, I have following data points: The dates are...
I have tried the following formulas with no success: FILTER(A6:A25,$B$6:$B$25=MEDIAN((B2*0.9),(B2*1.1))) Returns only "DE-1" FILTER(A6:A25,AND(B6:B25>B2*1-B3),B6:B25<B2*1+B3) Returns only "TRUE", FALSE" FILTER(A6:A25,(1-ABS(B6:B25/(B2<B2*(1+B3))) Returns all ...
First, let me tell you that I am alright at Excel, but am by no means an expert. I have a formula our users are using, where they now want to remove...
Figure 1.Ferrari SF70H, a 2017 spec. car. Extracted from Reddit [9]. This work can be considered to be contemporary study, as very few sources have extracted meaningful conclusions regarding the latest F1 aerodynamic package. Accordingly, the originality of this work recalls on the judgement ...