Editing an IF statement to include a value as a currency

Hi All,

Im currently doing a project, and I have this if statement which gives me what I need in order to produce my graphs.

Here is the formula that I am using: =IF(All!$D$5="Paint Grade Qty",Data!B9,IF(All!$D$5="Painting Grade Val",Data!C9)) ---------> (Where $D$5 is a data validtion drop down box to select which option to choose and B9 & C9 are the qty and val data)

When the user clicks on the drop down box and selects painting grade Vol, the data along with the graph will change to vol and if the user selects painting grade Qty, then all the data and graph will change to the qty, however, on the graphs, I have a primary and secondary axis, but I would like the secondary axis to display the currency rather than just numbers, would I need to alter the formula in a way such that the data would display as currency, if so how would I alter the if statement?

If I changed the format of the data it would mean that the qty would then show as currency not only in the data but in the graphs as well.

Any help would be appreciated, hope its not too confusing?

Thanks

Ahhh, you see, I came to the right place, it seems that I am over complicating things that can be done if I go back to basics.

Thanks very much!

Ahhh, you see, I came to the right place, it seems that I am over complicating things that can be done if I go back to basics.

Thanks very much!