View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default 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