SOS-Needing help in performing a what if analysis

  • Thread starter Thread starter Donna
  • Start date Start date
D

Donna

Can anyone help me in performing a what if analysis. I
need to enter a value in a cell to cause it to go from
less than 1% to equal 10.0%.
 
-----Original Message-----
Can anyone help me in performing a what if analysis. I
need to enter a value in a cell to cause it to go from
less than 1% to equal 10.0%.
.
=IF(F1<1%,10%,F1) will give you 10% if the cell F1 is
Click to expand...
less than 1%; otherwise it will give you what was in the
cell (if it is =1% or greater). Then format the cell to
give you one decimal place if you choose.
Hope this helps. I wasn't quite sure what you wanted to
do with it if it were equal to or over 1%.
 
If you mean you have to adjust a variable in a cell such that all the other
cells that are linked to it will arrive at a calculated answer of 10% then you
need to look at Tools / Goalseek, or Tools / Solver. Set the cell you wish to
be a certain value, give it the value, and then tell it which cell you want to
change in order to make it happen. It will do the rest.
 
Hi
not really sure what you're trying to do. You may post an example of
what you're trying to accomplish
 
Back
Top