new Q

[bn_dubai]

Dear all

example
i have c9 and the fourmial ic c9=c2+c5

but if in c5 number =6
and nothing in c2=
the answer in c9 will be = 6

but i don't want this operation to act if nothing in c2 or C9

so can you help me in this

Regards

 

[Norman Jones]

Hi Bn_dubai,

One way:

=IF(COUNT(C2,C5)=2,C2+C5,"")