2 different formulas in a single cell

shashi shetty 21 Reputation points
2020-08-19T09:49:39.047+00:00

This specifically refers to formulas in the following cells
CELL E1 =C1*D1
CELL E2 =1/C2-1
CELL F2 =D2*(1-E2)

In 1st row Cell A1 is 1.33times greater than Cell B1 so the Cell D1 has been multiplied 1.33times in

Cell E1,
In 2nd row Cell A2 is 0.33times lesser than Cell B2 hence in my formula spread between Cell E2 &

F2 the Fig. of D2 Cell has been reduced by 0.33times as visible in Cell F2.

I am trying to find a simple formula wherein I can merge/combine the formulas as mentioned in

E1,E2&F2 in to a single formula

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
0 comments
Accepted answer
  1. Vaibhav Chaudhari 38,676 Reputation points
    2020-08-19T10:30:24.22+00:00

    The tag "qna-feedback" used in the question is for feedback on this QnA forum.

    I would suggest to post the question with dedicated tag for excel i.e. "office-excel-itpro"

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,581 Reputation points
    2020-08-20T01:49:08.273+00:00

    Hi shashi shetty,

    I think you may enter the formula in E1 =IF(A1>B1,A1/B1*D1,D1*(2-B1/A1)), then pull down, you would get the original F2 value in E2 now.

    18859-capture20.jpg

    Any misunderstanding, please let me know.