Forum Discussion
atta1122
Aug 22, 2021Copper Contributor
Multiple Formula In A Single Cell
I'm facing a problem if you could find its solution. In cell A1 7650 In cell B1 =À1*20% (Value in cell B1 = 1530) In Cell C1 =B1*30% (Value in cell C1 = 459) In cell D1 =Sum(B1+C1) (Va...
AA-ACTS
Oct 10, 2022Copper Contributor
Hi Hans,
That was amazing it is working alright, thank you very much!
Please can you do the formula vice versa now I need to find the column.
That was amazing it is working alright, thank you very much!
Please can you do the formula vice versa now I need to find the column.
HansVogelaar
Oct 10, 2022MVP
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),"")
- AA-ACTSOct 10, 2022Copper ContributorHi Hans,
Thank you very much, it is working.
That was amazing.