One is the lookup, which is a pain in the rear end. To really get fancy as you indicated the want for color coding, use conditional formatting of the cell to make current green and not current red.įor your first formula regarding the actual currency computation, I think there are a couple of ways to tackle that one. If you have 6 or greater, it will show current. If you have 5, it will dsiplay not current. ( change sheet1! to your Flightlog sheet name and **change the cell references **to your value total of instrument approaches. If you want the formula to look back to a data sheet, then use the following. I placed it in the data worksheet, where as your formula looks like it was on a different sheet (flight log). =IF(A3>=6, “current”,“not current”), this worked for me, but I did not have it referring to another sheet as indicated in your example. I will talk in thoughts for your first formula after resolving your second formula question. Something told me in the background this would be a IA currency questionįor your second formula, this is easy enough for me. Looking at the spreadsheet will help so please email it to me at trying to make a formula to calculate if I am instruemnt current. If this number is 8 or more, the the conditional formatting will make the cell green other it will be red. Basically, it the formula would say sum all currency indicators within the past 180 days. I would use conditional formatting to indicate currency.ĭepending on how the worksheet is setup, I’d use the sumif function to determine currency. Without looking at the full spreadsheet, I can offer some advice. I also need help with the formulas for: Cross Country Instruction received, Cross country Solo, Cross Country PIC, Night Instruction Received Night PIC, Night SIC and Cross Country SIC.

You might need to look at the spreadsheet I have in order for it to make sence. Then this is the formula to tell me if I’m instrument current This is the formula I have to calculate instrument approaches in 180 days.

Instrument Current: Yes (In Green) or No (in red) I’m trying to make a formula to calculate if I am instruemnt current.

Excel logbook for pilots