Multiple IF And statements using ToNumber causing error

[ChyristinaBrown]

I'm trying to create tiering based on revenue (number field).  I'm having an issue with a formula, and I can't pinpoint what the problem is.  

IF ToNumber([MR Revenue (USD$)]<100000000) THEN "Up To 100 million"

ELSEif

ToNumber([MR Revenue (USD$)]>100000000) AND ToNumber([MR Revenue (USD$)]<500000000) then "$100 million To $500 million"

elseif

ToNumber([MR Revenue (USD$)]>500000000) AND ToNumber([MR Revenue (USD$)]<5000000000) then "$500 million To $5 billion"

elseif

ToNumber([MR Revenue (USD$)]>5000000000) AND ToNumber([MR Revenue (USD$)]<25000000000) then "$5 billion To $25 billion"

else "Unknown" ENDIF

The expression turns black at the bolded portion.  I can't figure out why though.  

Any thoughts?

[atcodedog05 · Accepted solution]

Hi @ChyristinaBrown 

You need to only pass field into ToNumber() function like below <100000000 should be outside like below.

IF ToNumber([MR Revenue (USD$)])<100000000 THEN "Up To 100 million"

ELSEif

ToNumber([MR Revenue (USD$)])>100000000 AND ToNumber([MR Revenue (USD$)])<500000000 then "$100 million To $500 million"

elseif

ToNumber([MR Revenue (USD$)])>500000000 AND ToNumber([MR Revenue (USD$)])<5000000000 then "$500 million To $5 billion"

elseif

ToNumber([MR Revenue (USD$)])>5000000000 AND ToNumber([MR Revenue (USD$)])<25000000000 then "$5 billion To $25 billion"

else "Unknown" ENDIF

Hope this helps 🙂

[ChyristinaBrown]

That works.  Thank you.