Ask Search:
Jennifer ScheideggerJennifer Scheidegger 

Error: Incorrect number of parameters for function 'IF()'. Expected 3, received 4

Getting the  " Incorrect number of parameters for function 'IF()'. Expected 3, received 4" forumula error when trying to write a formula on the opportunity amount field to display a range value.
Below is my forumula. I really appreciate any insight into what  I am doing incorrectly! 

IF (Amount > 99999.99, "$100,000+",
IF (Amount > 24999.99, "$25,000- $99,999",
IF (Amount > 9999.99, "$10,000-$25,000",
IF (Amount > 4999,99, "$5,000-$9,999",
IF (Amount > 2499.99, "$2500-$4,999",
IF (Amount > 999.99, "$1000-$2499",
IF (Amount >499.99, "$500-$999",
IF (Amount > 249.99, "$250-$499",
IF (Amount > 1.00, "$1.00-249","")))))))))
 
Best Answer chosen by Jennifer Scheidegger
Tony TrinhTony Trinh
Hi Jennifer,

Your 4999.99 has a comma. It is a typo. You need the .

Tony

All Answers

Tony TrinhTony Trinh
Hi Jennifer,

Your 4999.99 has a comma. It is a typo. You need the .

Tony
This was selected as the best answer
Jennifer ScheideggerJennifer Scheidegger
Tony, 
Thank you! I can't believe I didn't catch that!