how to make a cell readout a certain number based on the number from a different cell

[tw627x]

Hello all,

I have two charts, one chart has money amounts in it ie. 9.99, 10.00, 30.00 and so on. my second chart is doign math for me based off of my first chart. what I need is the second chart to display the same number or sometimes a different number based on what the number is. So cell G20 needs to display the same thing as cell g3 when the total in g3 is 9.99, but when g3 says 10 cell g20 needs to display 30. i have used this equation =IF(G3=10,"$30.00",G3) to get cell g20 to dsplay 30 when cell g3 says 10, but i need it to also display 30 when cell g3 says 35,40,45,50. any help would be appreciated

[daffodil11]

This might work:

=IF(OR(G3=10,G3=35,G=40,G3=45,G3=50),"$30.00",G3)

[tw627x]

This might work:

=IF(OR(G3=10,G3=35,G=40,G3=45,G3=50),"$30.00",G3)

Perfect!! works like a charm! thanks!

[Tony Valko]

This might work:

=IF(OR(G3=10,G3=35,G=40,G3=45,G3=50),"$30.00",G3)

Here's a shortcut:

=IF(OR(G3={10,35,40,45,50}),"$30.00",G3)

Also, are you sure you want to put quotes around 30? Quoting numbers turns them into TEXT strings.

The general rule of thumb is...

Quote TEXT but don't quote numbers.

"Yes"
30
"X"
1002

=IF(OR(G3={10,35,40,45,50}),30,G3)

Then, if you want it to display as $30.00 use cell formatting.