Formula

[Kjaer]

Hi

I have made a calculation like this

Factor	Value	Calculation
A	10	20
B	20	60
C	30	120

In my dataset I have data for this three factors. Is it possible to make a condition if there is no data for f.ex. factor C?

I don´t want to delete the fomulas, because f.ex in my dataset for Q1 there is only data for f.ex. factor A and B, and later in my data for Q2 I have data for all three factors. 

[geraldo]

@Kjaer 

I didn't understand what you want but I made an example flow of recording a formula for generating an excel.

[Kjaer]

Hi Geraldo

Thanks for your answer. I think it will work and will give it a try.

Best regard

Thomas

[Kjaer]

Hi again

It didn't work as expected and to be honest, my explanation was not the best. So I will give it a new try:

I have these three lines and in one "fomula" I have made a calculations for each column A, B and C. But if my data do not contain any data for f.ex column C, I would like to make a condition, that if no data in column C, then just skip the calculation.

Number	A	B	C
5000	5	10	15
5001	10	20	30
5002	15	30	45