May 30 2019 06:17 AM - edited Jun 03 2019 08:45 AM
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 by reversing the IF statement. It didn't work so I tried to handle it with an IF statement later to handle that in the total sum, but that lead to it not printing the sum altogether.
Here's the M11 formula =IF(C11>1, IF(C11>250,IF(C11>500, IF(C11>1000,IF(C11>3000,5000,5000),3000),2000),1000), 1)
and here's the M13 forumla =IF(1,0,(M10+M11+M12))
Would prefer to fix the M11 formula.
May 30 2019 09:16 AM - edited May 30 2019 09:20 AM
May 30 2019 09:42 AM
Default greater than 3000 to $5000
3000< = $5000
1000< = $3000
500 < = $2000
250 < = $1000
100 < =$1
0 = 0
May 30 2019 10:01 AM
May 30 2019 11:33 AM
Just realized all of those carrots were facing the wrong way, but the concept should still be there. I'm trying to do number ranges so between 1000-3000 should print $5000 and so on.
May 30 2019 12:16 PM
Jun 03 2019 05:46 AM
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
Jun 03 2019 08:33 AM
SolutionJun 03 2019 08:39 AM
Jun 03 2019 08:33 AM
Solution