g10

Hi Everyone, I’m trying to create a formula that uses both negative and positive percentages and doesn’t have any false statements. I would like it to be if cell G10 is >= -30% then G12 should display “partial response”, if G10 is <-30% then G12 should display “stable disease” or if G10 is >+20%...

I have the following Formula: =IF($D23="M/L",LOOKUP($F23,$M$12:$M$15,$N$12:$N$15)) Column D has values of "Hybrid", "Small" and "M/L" Column F has values of "G7", "G8", "G9" and "G10" M12:M15 and N12:N15 looks like this: <colgroup><col style="width:88pt" width="117" span="2">...

Hi Everyone, I'm thinking this might be impossible as the possabilities are too wide, however I've been surprised before so who knows? I have a sheet where people input the clients Name "Woolworths Ltd" or "Amazon" etc. now I'm having a problem as the names are being entered differently. I've...

Im trying to calculate work time and overtime. The basic hours are 8, overtime at time and a half is between 8 hours and 12 hours, and double time is over 12 hours. so if the total hours worked in G7 that day are 14:30, then how do I get cells Basic G8 = 8:00, OT 1.5 G9 = 4:00 and OT 2.0 G10 =...

Good Evening everyone, I have two cells, lets say G10 and H10, with a formula (say =G4-(SUM(G6:G9) ) and the second cell is exactly the same formula but referencing the next column. Then in cell F10 I have a formula generating text based on the results of G10 and H10. All these formula are...

Hi, I've currently got a load of timestamps in column J, generated by pressing a button. I wondered if anyone would be able to tell me how to get cell G10 to turn green if 3 or more of the timestamps are in the same day? Thanks!