=IF(AND(I1>="09/01"+0,I1<="11/30"+0)I1>=12/30<=02/29+0)"8.0%","7.5%","9.0%")
I am trying to do a formula that has three different out comes
if I1 (date) is March thru August the % is 7.5
If I1 (date) is Sept thru October the % is 8.0
If I1 (date) is Nov thru Feb the % is 9.0
Can any one help
I am trying to do a formula that has three different out comes
if I1 (date) is March thru August the % is 7.5
If I1 (date) is Sept thru October the % is 8.0
If I1 (date) is Nov thru Feb the % is 9.0
Can any one help