Microsoft Office Forums - View Single Post - Use of named ranges based on cell content

Thread: Use of named ranges based on cell content

View Single Post

Old

02-24-2019, 07:33 AM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

I think you would be better off adopting something like...

=IF(OR(A1={1,2}),IF(A1=1,sub_1,sub_2)+5,"")

Now in cell A1, you select between 1 and 2 to use either sub_1 or sub_2 plus the 5 days

Reply With Quote