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)
