A
Andy
Hi everyone,
I wanted to know if there is a way to produce an outcome
in a cell due to something being selected in a combo box.
e.g. in a combo box there are three factors (none,
hospital fees, room service), and i want to show the cost
of these in another cell the IF function would be perfect
but can only produce 2 outcomes. Is there a way i can do
this with the outcome being 0 for none, hospital fees
being 200, and room service being 50.
Hope you can help!
Andy
I wanted to know if there is a way to produce an outcome
in a cell due to something being selected in a combo box.
e.g. in a combo box there are three factors (none,
hospital fees, room service), and i want to show the cost
of these in another cell the IF function would be perfect
but can only produce 2 outcomes. Is there a way i can do
this with the outcome being 0 for none, hospital fees
being 200, and room service being 50.
Hope you can help!
Andy