Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculating values in cells
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculating values in cells
As for the logic:
=OR(AND(A1,C1),OR(AND(A1,NOT(C1)),AND(NOT(A1),C1)) ) This formula returns TRUE if only A1 has a TRUE value or only C1 or both. But it isn't clear, what should the formula in F1 return if A1 and C1 don't meet your criteria? Regards, Stefi €˛antonov€¯ ezt Ć*rta: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculating values in cells
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate values in an unlimited range of cells in a column WITHOUTalso calculating values that had previously been filtered AGAINST? | Excel Discussion (Misc queries) | |||
How to use date for calculating values in other cells | Excel Worksheet Functions | |||
Pbl calculating US$ values | Excel Discussion (Misc queries) | |||
Calculating Non-Constant Values in Cells | Excel Programming |