IF formula syntax help 1

[sandora]

Ver XI, AccessDB

This is what I have, but I don't know what the correct syntax would be to get it to work. These are trailer types and are defined in a formula 'trailer types'

F,UF,LQ,UL = 500
NL,UN = 200
C,UC <2000 = 25
>=2000 and <6000 = 50
>=6000 = 100

I was thinking if, then, else but you guys are so good at this stuff, I thought there might be a better way.

 

[sandora]

Ok, this may make more sense and it will work until I add the second condition for Total Vehicle Cost. Can anyone help, please.

if {00_Veh_Inventory.Veh Type} in ["F","UF","LQ","UL"] then 500
else
if {00_Veh_Inventory.Veh Type} in ["UN","NL"] then 200
else
if {00_Veh_Inventory.Veh Type} in ["C", "UC"] and

if {FI_Profit.Total Vehicle Cost} < 2000 then 25 or

if {FI_Profit.Total Vehicle Cost} => 2000 and <6000 then 50 or

if {FI_Profit.Total Vehicle Cost} >= 6000 then 100

else 0

 

[lbass]

That's much clearer. Try:

if {00_Veh_Inventory.Veh Type} in ["F","UF","LQ","UL"] then 500 else
if {00_Veh_Inventory.Veh Type} in ["UN","NL"] then 200 else
if {00_Veh_Inventory.Veh Type} in ["C", "UC"] then
(
if {FI_Profit.Total Vehicle Cost} < 2000 then 25 else
if {FI_Profit.Total Vehicle Cost} >= 2000 and
{FI_Profit.Total Vehicle Cost} < 6000 then 50 else
if {FI_Profit.Total Vehicle Cost} >= 6000 then 100
)
else 0

-LB

 

[sandora]

I knew I was close, thanks so much, works great.