Problem with formula

[Dmrs92]

[TABLE="class: forumline, width: 100%"]
<tbody>[TR]
[TD="class: row1, width: 150, align: left"]
Posty: 3

[/TD]
[TD="class: {.ROW_CLASS}, width: 100%"][TABLE="width: 100%"]
<tbody>[TR]
[TD]Wysłany: Dzisiaj 18:12 Pomysł na formułe[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD="colspan: 2"]

---

[/TD]
[/TR]
[TR]
[TD="colspan: 2"]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,[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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)