Problem with formula

[Dmrs92]

Posty: 3

Wysłany: Dzisiaj 18:12 Pomysł na formułe Hi, I need your help with this formula: If.error( If(t2>=0;Z2=t2 but if t2 is bigger than y2 show y2 and the second part is iF(Y2+T2<0;-Y2;T2);""). But how to merge it ? Something like that =If.error(IF(t2+y2>=0;z2=t2<=y2);IF(Y2+T2<0;-Y2;T2);"") But it is not working, please help. Thank you in advance, <tbody> </tbody>

<tbody>
</tbody>

 

[mole999]

drop the if.error first of all, it dose.nt have a dot and will stop you from debugging initally

 

[Dmrs92]

Sorry, i know normally i'm using diffrent laguage. Of course in english it should be without dot. But still, it's not working.The problem is the part after first If.

 

[Joe4]

This is not a valid formula in VBA:

[COLOR=#333333]z2=t2<=y2[/COLOR]

It would need to be:

=AND(z2=t2;t2<=y2)