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