I have 5 cells A-E named Distance, Time, Race time, Diff, Going

my normal calc is (D/A)*3 which gives me E

I need a formula that shows 0 in E if 0 is entered in C or else shows my original calc.

Hope you can understand my query.

regards

David B

- Thread starter slovak
- Start date

I have 5 cells A-E named Distance, Time, Race time, Diff, Going

my normal calc is (D/A)*3 which gives me E

I need a formula that shows 0 in E if 0 is entered in C or else shows my original calc.

Hope you can understand my query.

regards

David B

can anyone help?

I have the following statement, which gives a result in cell A26 "=(135-(A18*10)-(A19*A20)+(SUM(A21:A24)))"

I would like to change the values of A19, if a specific number is entered

e.g. enter 12 and it would become 18 or enter 16 and it would become 24, otherwise the statement remains unaltered

Regards

David B

I need a solution please

cell A19 can have different numbers (8, 9, 12, 16) entered, which gives me a result in A27.

If "8" is entered the resulting value remains unaltered,

if "9" is entered, "9" becomes (9*1.25).

If "12" is entered, "12" becomes (12*1.5).

If "16" is entered, "16" becomes (16*1.75).

regards

David B

my problem(can't seem to get the solution) is:

I have a list [A6*A7+A8/A9+A10], which has 2 possible totals, [CELL A12 or CELL A13] depending on the input value in [CELL 9]. If the input is <9 then the total shows in [CELL A12] leaving [CELL A13 blank), NO PROBLEM, but when the value input is >=9, I need a formula to make [CELL A12] blank and the result appear in [CELL A13], BUT OBVIOUSLY NEED THE TOTAL FROM {CELL A12]