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.
0 kommentar(er)
