Hi everyone,
I am trying to write a formula using the if function,
I have a combo box with the following list inside,
No Of Quarantined Incidents
No Of Units Quarantined
No Of Bins Quarantined
Total Cost Quarantined
Average Units Per Incident
Average Bins Per Incident
Average Cost Per Incident
I have 1 cell that will display the above results, I want that cell to display the values correctly in the correct format, so if I choose Total Cost Quarantined or Average Cost Per Incident there will be a £ sign and the value, if I click on the others I want them to display the values without the £ sign. I can get the £ sign with the values with the following =IF(K100="Average Cost Per Incident",CONCATENATE("£",INDEX(tblChosen,$J$107,$P$101)),INDEX(tblChosen,$J$106,$L$101)). But where do I put the "Total Cost Quarantine" inside the formula??, I have tried numerous ways but I'm having no luck. P.S K100 is a cell that displays whatever has been chosen in combo box. Thank you very much for you help.
Bookmarks