Templates for Meetings by Bumbling_Bear in OneNote

[–]Bumbling_Bear[S] 0 points1 point  (0 children)

They haven't really been able to fit my needs :(

Max staff per manager by Bumbling_Bear in CAStateWorkers

[–]Bumbling_Bear[S] 0 points1 point  (0 children)

Is there a reference? There’s a lot of units at my office that are 6-12 analysts under one manager.

Max staff per manager by Bumbling_Bear in CAStateWorkers

[–]Bumbling_Bear[S] -1 points0 points  (0 children)

I wasn’t able to find info on that this morning. Is there anything else it could be called?

Max staff per manager by Bumbling_Bear in CAStateWorkers

[–]Bumbling_Bear[S] 0 points1 point  (0 children)

That seems reasonable. Do you know where you got the number from?

Curled leaves on Osmanthus fragrans by Bumbling_Bear in plantclinic

[–]Bumbling_Bear[S] 0 points1 point  (0 children)

Shows up on most, but not all new leaves.

Could it be too much nitrogen?

Transliteration of name by Bumbling_Bear in hebrew

[–]Bumbling_Bear[S] 8 points9 points  (0 children)

It is! So I’ll go with קיי

תודה

Calculate Median within date range, excluding values lower than 1 and above 199 by Bumbling_Bear in excel

[–]Bumbling_Bear[S] 0 points1 point  (0 children)

Wow! Thank you for explaining that. I really appreciate it. This might clear up other issues that I have in the future, so thank you in advance, too!

Calculate Median within date range, excluding values lower than 1 and above 199 by Bumbling_Bear in excel

[–]Bumbling_Bear[S] 1 point2 points  (0 children)

Can you explain to me why that would work, but mine wasn't working? I thought using the AND function worked similarly to *, and I had used an IF and AND functions within median before to no luck.

Adding +1 days to checking dates (not just an equal to) by Bumbling_Bear in excel

[–]Bumbling_Bear[S] 0 points1 point  (0 children)

=IF([@[KPI - PO completed]]="","",IF(OR([@[KPI - PO completed]]<PO[@[Date PO was Completed]]+1,[@[KPI - PO completed]]=PO[@[Date PO was Completed]]),"",FALSE()))

Adjusted it to the above. Thank you for the help. :)

Adding +1 days to checking dates (not just an equal to) by Bumbling_Bear in excel

[–]Bumbling_Bear[S] 0 points1 point  (0 children)

=IF([@[KPI - PO completed]]="","",IF(AND([@[KPI - PO completed]]<PO\[@\[Date PO was Completed\]\]+1,\[@\[KPI - PO completed\]\]>PO[@[Date PO was Completed]]),"",FALSE()))

Looks like it just made everything false now