I have a data set, in which i need to do some calculations and report.
Here is my problem.
I have the headers like SP, CP and Conf CP. My calculation is like below:
I) Value = (SP-Conf CP)/SP*100
II) Value = (SP-CP)/SP*100
In most of the cases, my “Conf CP” will be ‘o’ and in such cases i should proceed with the second formula. But when there is value for “Conf CP” i should ignore the second formula and proceed with first formula.
Whether excel has the capability in doing this, if so, how we do it?
Please let me know!
