I would so greatly appreciate any help anyone could give me... I've been working on this for days now!
The spreadsheet I'm using has 2 worksheets. On the first worksheet, I would like a line to appear that says "Director Approval Required" whenever any one of these numbers (2280, 2294, 3553, 5644, 6445 and 7332) is typed into any one of the cells B6-B59 on the second worksheet (named "Itemized").
Using this formula,
=IF(Itemized!B6-B59=2280,"DIRECTOR APPROVAL REQUIRED:","")
I can get the above text to appear when 2280 is entered into any one of the cells B6-B59, but I can't get it to appear when any one of the above numbers is typed into any one of those cells.
I hope I am making sense. Thank you so much in advance for any help you may offer.
The spreadsheet I'm using has 2 worksheets. On the first worksheet, I would like a line to appear that says "Director Approval Required" whenever any one of these numbers (2280, 2294, 3553, 5644, 6445 and 7332) is typed into any one of the cells B6-B59 on the second worksheet (named "Itemized").
Using this formula,
=IF(Itemized!B6-B59=2280,"DIRECTOR APPROVAL REQUIRED:","")
I can get the above text to appear when 2280 is entered into any one of the cells B6-B59, but I can't get it to appear when any one of the above numbers is typed into any one of those cells.
I hope I am making sense. Thank you so much in advance for any help you may offer.
