Assistance Require with IF, ELSE statement

Hi,

I'm new to these forums. I thought I would request here for help, since this is bugging me how to do it.

What I want to do is make an IF ELSE function, but in the ELSE side, I want to write a formula. I'll explain. My IF will state "=IF>=.78,"You're Fine",You Need 'x' to get to 78%".

So, my question is, how to I begin to write a formula for 'you need 'x' to get to 78%. Here is how I have outlined my spreadsheet.

Cell A1=1
Cell A2=0
Cell A3=1
Cell A4=(A1-A3)/Sum(A1:A3)

If I use the above example, I'm at 0%. Now, I need 8 more in Cell A1 to show a number higher than 78% in cell A4. Cell A5 would contain the IF ELSE statement. How do I write this in Excel? I hope I have not confused anyone. Thanks.

Thanks for the reply, however I need the part where it says "You need X (X being some number) to get to 78%" to do a calculation that if A4 is not 78% or higher, that it needs to calculate how many more I need to reach 78%.

Thanks Bebo. Is that formula dynamic? Let's say I change the content of Cell A1 to 2. Then you need 6 more to reach to 78% or higher. I guess, can Excel do dynamic formulas?

Thanks. You almost got it. I think. What I'm going after is a 'GOALSEEK' formula. First, D4 is the sum of A4+B4+C4. Therefore, if A4-C4/D4*100 is less than 78%, I want to know what what value plus the value all ready in A4 will get me to 78%, which is what is shown in the cell H4. H4 is A4-C4/D4*100.

And I'm sorry about all the confusion. I'm working in excel after a very long time.