calculating values in cells
Forget what I said, simply write =(A1+C1)*0.2 in F1, Excel will calculate as
follows:
A C F
0 0 0
0 1 0,2
1 0 0,2
1 1 0,4
Regards,
Stefi
€˛antonov€¯ ezt Ć*rta:
Stefi,
if both A1 and C1 are empty then F1 = 0
if either 0 then F1=(A1+C1)*0.2
"antonov" wrote in message
...
A1 and C1 may or not have a value (A1 and C1, or A1, or C1).
F1=((A1+C1)*0.2) (still only A1 can have a value or only C1 or both).
How can I write this formula?
thanks
|