I have a cell (U52) that uses the following formula to work out what the value should be based off of text in another cell:
=IF(K52="CPM",L52,ifs(F52="Education",(L52/0.0053),F52="Property",(L52/0.0041),F52="Recruitment",(L52/0.0026),F52="Council",(L52/0.0029),F52="Other",(L52/0.003)))
I was wondering if there is a formula I can use in the cell immediately to the left (T52) to pick out the percentage used in the above formula. For example, if cell F52 contained "Property", this cell would show 0.41% (0.0041 expressed as a percentage).
Is this possible? I don't really want to recreate the above formula again as I will be updating the percentage values every fortnight or so, so would like to keep them linked if possible so that a change in the above formula will automatically be reflected in the other.
Aucun commentaire:
Enregistrer un commentaire