Forum Discussion

jhermesP's avatar
jhermesP
Copper Contributor
May 30, 2019
Solved

Issue with my IF statement

I'm trying to do an if statement where based on the number of employees it will spit out a price, but the way my formula is set up if there's 0 employees it will spit out a $1. I tried to handle this...
excel
  • Twifoo's avatar
    Twifoo
    Jun 03, 2019
    Given your latest clarification, the formula in M11 is perhaps:
    =LOOKUP(C11,
    {0,1,101,251,501,1001},
    {0,1,1000,2000,3000,5000})
jhermesP's avatar
jhermesP
Copper Contributor
Jun 03, 2019

Twifoo 

If C11=0, M11=0

If 1<C11<100, M11=$1

If 101<C11<250, M11=$1000

If 251<C11<500, M11=$2000

If 501<C11<1000, M11=$3000

If C11>1000, M11=$5000

 

Twifoo's avatar
Twifoo
Silver Contributor
Jun 03, 2019
Given your latest clarification, the formula in M11 is perhaps:
=LOOKUP(C11,
{0,1,101,251,501,1001},
{0,1,1000,2000,3000,5000})
  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Jun 03, 2019
    I’m delighted to have finally given you a solution!
  • jhermesP's avatar
    jhermesP
    Copper Contributor
    Jun 03, 2019
    Perfect! Thank you!