Thread: if formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sue Sue is offline
external usenet poster
 
Posts: 285
Default if formula

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.