Forum Discussion
Solved
If, then formula
I need a formula to figure out how much vacation time I'll have. From 1-36 months of service, I get 11 hours per month. Then, from 37-120 months of service, I'll get 14 hours per month. From 121-180 ...
_janelllllle , you may add helper range like this
The formula could be
=SUMPRODUCT((B9-$B$3:$B$7)*$C$3:$C$7*((B9-$B$3:$B$7)>0))
_janelllllle , you may add helper range like this
The formula could be
=SUMPRODUCT((B9-$B$3:$B$7)*$C$3:$C$7*((B9-$B$3:$B$7)>0))
This works perfectly! Thank you.
_janelllllle , you are welcome