ExcelBanter - can I use IF as a GO TO command?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - can I use IF as a GO TO command? (https://www.excelbanter.com/excel-worksheet-functions/65978-can-i-use-if-go-command.html)

Sharona77

can I use IF as a GO TO command?

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?

John Michl

can I use IF as a GO TO command?

Try...

=IF(AND(Months12, Months<25), OtherSheet!$A$1,"Do Something Else")

- John Michl

All times are GMT +1. The time now is 11:32 PM.