Excel Question please

[Mike]

Hi all

I have an excel question

I would like to input 2 figures : Target Cost and Actual costs in column A and B.

Based on these

If the actual cost is lower I would like to show the difference in column C and nothing in column D

If the actual cost is more I would like to show the difference in column D and nothing in column C.

See example attached

Would be grateful if anyone could please confirm the formulas I need to enter in columns C and D

Thanks you very much for any advice and your time

Regards

Mike

[MaccLad]

C1
=if(a1>b1,a1-b1,"")
copy/drag that value down for c2, c3, etc


D1
=if(b1>a1,b1-a1,"")
copy/drag that down for d2, d3, etc

[Mike]

Originally Posted by MaccLad

C1
=if(a1>b1,a1-b1,"")
copy/drag that value down for c2, c3, etc


D1
=if(b1>a1,b1-a1,"")
copy/drag that down for d2, d3, etc

Many thanks