f17

Hello all, I have a spreadsheet that tracks flight hours and the totals aren't always adding up correctly. If starting total of hours in cell F15 is 5092.0 and this particular days trip was 1.4 total in cell F16, the new total is showing up as 5093.5 in cell F17. Cell F15 is a locked cell and...

Hi All, Any help would be appreciated as this is driving me up the wall. I have three cells E17, F17, G17 that use a conditional format to display a tick/cross. F17 is a dummy cell that uses an If/Or statement to display "0" based on the contents of E17 and G17 I want to use a data...

=IF(AND(D17<=30,F17>9),"Yes"," ") D17 is -50 F17 is 4 The formula should say Yes if both conditions are true but it says Yes in this instance. I don't know why.

Hello, I am trying to work out an average of 2 cells however the 2 cells have a IF formula which is the selected from another cell. so on my page I have a dropdown option on 2 cells F17 & F18 (options = 3, 2, 1, N/A) Cells K17 & K18 have the formula =IF(F17=3, "100%",IF(F17=2, "66%",IF(F17=1...

Something has changed in the Forum. It used to be that when I pasted Excel data with the HTML Maker it would display the fill colours. Now, it doesn't (like here, where F17 though G32 should have been Green and also Rows 5 and 22 had some yellow...