How would I write the following formula? If A2=1 Then F2=B2*12*.67
D DILipandey Feb 12, 2009 #2 Hi You can use the following formula =IF(A2=1,B2*12*0.67,"A1 don't have 1") Thanks -- Dilip Kumar Pandey MBA, BCA, B.Com(Hons.) [email protected] [email protected] New Delhi, India
Hi You can use the following formula =IF(A2=1,B2*12*0.67,"A1 don't have 1") Thanks -- Dilip Kumar Pandey MBA, BCA, B.Com(Hons.) [email protected] [email protected] New Delhi, India