Hello. I'm having trouble with my formula for figuring rent per month based on total FTE/SNAP-Ed FTE. I am able to count the SNAP-Ed FTE if they work at least half the month. The formula I'm using is, =IF(F11>=$H$5,"0.00",IF(G11>=$H$5,D11,"0.00")); however, the formula isn't working in Row 11. The person only worked a total of 11 days so shouldn't show up as 1.00 FTE in Total November FTE but they do. Perhaps I'm missing another IF formula or I'm wondering if I should scrap this and try and figure by # of Days for each month.
Any suggestions would be greatly appreciated! Thanks in advance.
Any suggestions would be greatly appreciated! Thanks in advance.
Last edited by a moderator:
