Forum Discussion

g00361169's avatar
g00361169
Copper Contributor
Mar 05, 2020

what if Analysis

Using what if analysis how do I take in a column of values,increase them by a fixed percent,and output them too another column of the same length

 

excel

8 Replies

  • mathetes's avatar
    mathetes
    Gold Contributor
    Mar 05, 2020

    g00361169 

    That's a question that could have many answers. At the very simplest level, you want to use a field off by itself to enter that variable  percentage. I've attached a simple example. Please come back if I've missed your actual need.

    • g00361169's avatar
      g00361169
      Copper Contributor
      Mar 05, 2020

       

      mathetes 

      Thank you for taking the time too reply this might be give you a better indicator of what im trying to do,I want too populate the yellow column with the unit price value increased by  f12,the box with the 22% in it

      • mathetes's avatar
        mathetes
        Gold Contributor
        Mar 05, 2020

        g00361169 

         

        So this looks like a homework assignment of some kind. Right?

         

        In any event, I think the sample spreadsheet I provided above should give you the answer in terms of how to approach it. You'd have to adapt the formula to your specific sheet. (FWIW, an image is not all that helpful in requesting help on these pages; we almost always prefer a sample of the actual sheet.)

Resources