SOS-Needing help in performing a what if analysis

[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%.

 

[ncf]

-----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

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%.

 

[Ken Wright]

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.

 

[Frank Kabel]

Hi
not really sure what you're trying to do. You may post an example of
what you're trying to accomplish