I have an app where if a person choose one type of safety equipment there is a max amount that will be reimbursed up to that amount.
I am trying to write this but missing the syntax completely I think.
Switch(DataCardValue66.Text,
"Safety Toe Boots" & Value(DataCardValue75.Text) <= 300.00,DataCardValue75.Text, "300.00",
"Prescription Safety Eye Wear" & Value(DataCardValue75.Text)<= 250.00,DataCardValue75.Text, "250.00"
)
Basically if they purchase safety boots they will be reimbursed up to the value paid if less then 300 but if it is more then 300 they will only be reimbursed 300 the same for Safety Glasses.
Any help would be appreciated.
Solved! Go to Solution.
I would not recommend having these things written into your formulas like this (what happens when 300 needs to become 350?)
But, your formula should be:
Switch(DataCardValue66.Text,
"Safety Toe Boots",
If(Value(DataCardValue75.Text) <= 300.00, DataCardValue75.Text, "300.00"),
"Prescription Safety Eye Wear",
If(Value(DataCardValue75.Text)<= 250.00, DataCardValue75.Text, "250.00")
)
I hope this is helpful for you.
(p.s...haven't had a chance to look over your other message - hopefully shortly!)
I would not recommend having these things written into your formulas like this (what happens when 300 needs to become 350?)
But, your formula should be:
Switch(DataCardValue66.Text,
"Safety Toe Boots",
If(Value(DataCardValue75.Text) <= 300.00, DataCardValue75.Text, "300.00"),
"Prescription Safety Eye Wear",
If(Value(DataCardValue75.Text)<= 250.00, DataCardValue75.Text, "250.00")
)
I hope this is helpful for you.
(p.s...haven't had a chance to look over your other message - hopefully shortly!)
Perfect that worked like a charm.!!!
User | Count |
---|---|
258 | |
111 | |
95 | |
48 | |
41 |