IF Formula

[RanjanKT]

May i know what is wrong with the below formula.

Could some on help in correcting it.

if [TotalValueOfPotentialSale]<"100000" then "1. < 100k" elseif [TotalValueOfPotentialSale]>="1000000" then "5.=or>1 Million" elseif [TotalValueOfPotentialSale]>="100000" AND [TotalValueOfPotentialSale]<"250000" then "2.100k-<250k" elseif [TotalValueOfPotentialSale]>= "250000" AND [TotalValueOfPotentialSale]<"500000" then "3.250k-<500k" elseif [TotalValueOfPotentialSale]>= "500000" AND [TotalValueOfPotentialSale]<"1000000" then "4.500k- < 1 Million" else ""
endif

[Srini_Advik · Accepted solution]

Check the Data type of 'TotalvalueofP....' change from string to integer. also check remove "" Quotes from the number. Please refer the formula below.

if [TotalValueOfPotentialSale]<100000 then "1. < 100k"

[RanjanKT]

Thanks