f11

Hi, I am trying to get a formula to return one of three values for two cell, I have two cells (i.e. F11 and G11) if F11 has something in, I need cell I11 to return "In Progress" if G11 contains something then I11 to return "complete"... at this point, both F11 and G11 would have something in...

can someone answer this. This formula works =ROUND(IFERROR(LOOKUP(1E+100,SEARCH(" "&prod&","," "&list01&","),'2012 price changes'!$J$3:$J$2521),""),4) I have a cell, F11 that I have "J" in. I want the formula to go to F11 and replace J with what is in F11 I can't get the below to work...

hi! i wish someone could help me. i have problem with a cell (actually F11) with the formula =if(E11>=0.75,"mastered",if(E11>=0.25,"nearly mastered",if(E11>=0,"least mastered",""))) and the formula in cell E11is =iferror((D11/C11),""). my problem is that when ever E11 is in error the value in...

Hello, Coming to you guys looking for a little help. I attached the spreadsheet for reference. The cell I'm working on is F11. It has an equation in it that I need to link to two drop down selection. About 3/4 of the way through the function is "0.75" That is a fixed value I put, that I...