Aug 22 2021 01:32 AM
Aug 22 2021 02:18 AM
Aug 22 2021 02:22 AM
Aug 22 2021 02:28 AM
That's an array constant with the values of 100% and 30%.
A variation of the formula explains why @Riny_van_Eekelen uses 26%. The result of the sum is 26%.
=A1*SUM(20%*{1;0.3})
Aug 22 2021 02:29 AM
Aug 22 2021 02:36 AM
Aug 22 2021 02:43 AM
Aug 22 2021 09:57 AM
You may practically literally translate your text into formulas
---
In cell B1
=À1*20% (Value in cell B1 = 1530)
In Cell C1
=B1*30% (Value in cell C1 = 459)
or
=(A1*20%)*30%
In cell D1
=Sum(B1+C1) (Value in cell D1 = 1989)
or
=A1*20% + (A1*20%)*30%
or
=A1*20%*(1+30%)
Oct 10 2022 04:44 AM
Hi!
Please advise how to combine the below formula in single cell
=MATCH(V15,B2:B501,0) & =MATCH(V15,C2:C501,0)
Oct 10 2022 04:52 AM
Please explain what the end result should be.
Oct 10 2022 05:01 AM
Oct 10 2022 05:15 AM
Oct 10 2022 05:50 AM
Oct 10 2022 06:02 AM
Oct 10 2022 06:27 AM
Let's say you want to look at C2:U501. Use the following formula. If you don't have Microsoft 365 or Office 2021, confirm the formula by pressing Ctrl+Shift+Enter.
=IFERROR(MATCH(V15,INDEX(C2:U501,0,MIN(IF(C2:U501=V15,COLUMN(C2:U2)-COLUMN(C2)+1))),0),"")
Oct 10 2022 06:34 AM
Oct 10 2022 06:46 AM
Sure. Again, if you don't have Microsoft 365 or Office 2021, confirm by pressing Ctrl+Shift+Enter:
=IFERROR(MATCH(V15,INDEX(C2:U501,MIN(IF(C2:U501=V15,ROW(C2:C501)-ROW(C2)+1)),0),0),"")
Oct 10 2022 06:54 AM