Greetings Smart People...
I'm looking for a way to use different forumlae based on the contents of a cell. In the attached, column K calculates a number based on criteria applied against columns L-O. I'd like K to use the formula in K2 unless column H='CC Support' or 'BenX OE'. Then use the formula in K3 and K4 instead. Deal or No deal?
Thanks!
Bookmarks