Simple Question

[clumein2]

I'm new to excel so please bare with what is probably such a basic question for you folks.
I would just like to create a simple cell formula that works like this....

"If I enter the number 1 into a cell then the next cell to the right will display $4.00"
"If I enter the number 2 into a cell then the next cell to the right will display $6.00"

I know this is probably pretty basic, but I'm having a heck of time digging through the info on formulas.

Thanks much - I appreciate your help

Cliff

 

[fairwinds]

Welcome to the board!

Try:

=CHOOSE(A1,4,6)

format cell as currency.

 

[clumein2]

Man that was fast..........

It worked great...... what can I say?

Thanks fairwinds

 

[clumein2]

Just one more thing

Though the formula worked great but it leaves this: #VALUE! in the field. I assume it's waiting for the input in the left field.

I need to have the result field empty (not showing anything) until I input into the left.

What do ya think?

thanks

 

[Richard Schollar]

Something like:

=IF(A1="","",choose(a1,4,6))

Best regards

Richard