Member Avatar for uniquestar
uniquestar 26 Posting Whiz in Training

Hi, I am trying to put a large formula in with multiple "ElseIF"s i suppose you can call it into one cell. for some reason it won't let me put more than 7 "ElseIF"s in.

Any Help ASAP very much appreciated.

EDIT:
The formula I wat to use is:
"=IF(L2=””,””,IF(L2>100,L2,IF(L2>90,42,IF(L2>80,36,IF(L2>70,31,IF(L2>60,25.5,IF(L2>50,21,IF(L2>40,16.75,IF(L2>30,13.25,IF(L2>20,10.75,IF(L2>10,7.75,IF(L2>5,6.5,IF(L2>3,5.2,IF(L2>1,4,3.5))))))))))))))"

  • 1 Contributor
  • 0 Replies
  • 85 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.