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.