Thread: Excel Question please
View Single Post
Old 15-02-2022, 12:23   #1
Mike
cf.mega poster
 
Join Date: Jan 2004
Age: 63
Posts: 2,242
Mike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful one
Excel Question please
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
Attached Files
File Type: pdf Excel Question 1.pdf (66.2 KB, 8 views)
Mike is offline   Reply With Quote