can I use IF as a GO TO command?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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(Months>12, Months<25), OtherSheet!$A$1,"Do Something Else")

- John Michl
 
Back
Top