close
I want to autofill a cell with a number from a different worksheet, based
upon the numeric value of a different cell. Say it is 17 (months)- I want
to say if the number is more than 12, less than 25, then autofill with this
other worsheet's cell value. Can I do this?
Try...
=IF(AND(Monthsgt;12, Monthslt;25), OtherSheet!$A$1,quot;Do Something Elsequot;)
- John Michl
全站熱搜
留言列表
