Forum Discussion

atta1122's avatar
atta1122
Copper Contributor
Aug 22, 2021

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...
excel
Formulas and Functions
training
  • atta1122's avatar
    atta1122
    Copper Contributor
    Aug 22, 2021
    That's working but how 20 and 30% becomes 25%
    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Aug 22, 2021

      atta1122 

      Well, 20% plus 30% of 20% equals 26%. 

       

      • atta1122's avatar
        atta1122
        Copper Contributor
        Aug 22, 2021
        Ok that's good
        but I am not math guy that's beyond my approach
        is there any other easiest way to calculate all the stuff?
        And thank you for earlier response

Resources