Thread: Can you have a 3 if statements in one cell?

Here's my problem. I need for a cell to produce 3 different answers based on the number in a referenced cell.

If the the referenced cell is < 2,000 then I want the other cell to add 15% to the number.

If the referenced cell is 2,000 to 9,999 then I want the other cell to add 10%

and If the the referenced cell is 10,000 or greater, I want the other cell to add 5%

I also would like the result to be be rounded up to the nearest hundred.

I've managed to make a working formula for the 1st 2 statement but I can't figure out had to add the 3rd.

Here is the formula that I have:

=ROUNDUP(IF('Text Prep.Presswork.Bind'!B12<2000, 'Text Prep.Presswork.Bind'!B12*1.15, 'Text Prep.Presswork.Bind'!B12*1.1),-2)

Originally Posted by zbor

You don't need 3 but 2 IF's:

=A1*(IF(A1<2000, 1.15, IF(A1<10000, 1.1,1.05)))

This is exactly what i enter following your instructions:

='Text Prep.Presswork.Bind'!B12*(IF('Text Prep.Presswork.Bind'!B12<2000, 1.15, IF('Text Prep.Presswork.Bind'!B12<10,000, 1.1, 1.05)))

I received an error message that said: You've entered too many arguments for this funtion

Did I do something Wrong?

Originally Posted by zbor

remove , from number:

='Text Prep.Presswork.Bind'!B12*(IF('Text Prep.Presswork.Bind'!B12<2000, 1.15, IF('Text Prep.Presswork.Bind'!B12<10,000, 1.1, 1.05)))

and write just 10000

This totally worked!!! Thanks so much for your help!!!