S
Sue
Need help with this formula.
If AH12 minus AL7 is greater than 0 but less than 30, then AH12 minus AL7
times AE7, if AH12 minus AL7 is greater than 30, then return value in AE7, if
AH12 minus AL7 is less than 0, return blank.
(AH12 and AL7 are dates)
AE7 is a monthly rate.
If AH12 minus AL7 is greater than 0 but less than 30, then AH12 minus AL7
times AE7, if AH12 minus AL7 is greater than 30, then return value in AE7, if
AH12 minus AL7 is less than 0, return blank.
(AH12 and AL7 are dates)
AE7 is a monthly rate.