Need help with formula

[redskinsfan]

Hi. I am trying to come up with a formula that tells you how you would would have to perform to reach a certain goal. I have a spreadsheet that a person enters a daily value. The average of the daily value must be 92% or greater. If the person is not at 92%, they enter the number of workdays left, and then I want Excel to figure out how much the person would need get to get per day (average) to meet 92%. What would the formula be given I have the daily average, and I know the number of days left to meet 92%?

Thanks in advance,
Mark

 

[Doug.T]

If A2=average and A3=days then....

=IF(A2<.92,(0.92-A2)/A3,"")