IF Formula
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Error Message
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator