# Conditional Formula Switcher

1. ## Conditional Formula Switcher

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!

2. Try this:

=IF(OR(H2="CC Support",H2="BenX OE"),IF(L2<90%,0,IF(M2=100%,4,IF(M2>=95%,3,0)))+IF(L2<90%,0,IF(N2>35%,0,IF(N2>=31%,3,IF(N2>0%,4,0)))+IF(L2<90%,0,IF(O2>1,4,IF(O2>=0.6,3,0)))),IF(L1<90%,0,IF(M1=100%,4,IF(M1>=95%,3,0)))+IF(L1<90%,0,IF(N1>35%,0,IF(N1>=31%,3,IF(N1>0%,4,0)))+IF(L1<90%,0,IF(O1>=1.6,4,IF(O1>=1,3,0)))))

3. Thanks a bunch!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1