b1103y New Member Jul 4, 2018 #1 Anyone know why the green cell formula is not working ? I included excel file in the attachment. Thank you, appreciate your help! Attachments Book1.xlsx 13.8 KB · Views: 16
Anyone know why the green cell formula is not working ? I included excel file in the attachment. Thank you, appreciate your help!
B bosco_yip Excel Ninja Jul 4, 2018 #2 Hi, Change your D19 formula (highlighted green) from this : =IF(D19="","", $C19*D12) Into this : =IF(D12="","", $C19*D12) Regards Bosco
Hi, Change your D19 formula (highlighted green) from this : =IF(D19="","", $C19*D12) Into this : =IF(D12="","", $C19*D12) Regards Bosco
b1103y New Member Jul 4, 2018 #3 bosco_yip said: Hi, Change your D19 formula (highlighted green) from this : =IF(D19="","", $C19*D12) Into this : =IF(D12="","", $C19*D12) Regards Bosco Click to expand... Thank you Bosco!
bosco_yip said: Hi, Change your D19 formula (highlighted green) from this : =IF(D19="","", $C19*D12) Into this : =IF(D12="","", $C19*D12) Regards Bosco Click to expand... Thank you Bosco!