IFS formula doesn't work

[Romano_odK]

Good morning,

I have a some disagreement with the below formula. What I want to accomplish is when the value of cell L6 and O6 are the same I get "ok", but that doesn't happen. I tried rounding this part (P6*$O$2)+P6), but didn't succeed either. Does anymore have an idea how to accomplish this.

Thank you for your time and efford

Romano

=IFERROR(IFS(((P6*$O$2)+P6)-L6="0";"ok";P6<>0;(100%-((L6*AU6/P6)))*-100%-$O$2);"")

Artikelen beheren XML 5.05.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Importdatum	15/12/2023	C:\TEMP\ART038_2023-12-15.XML			C:\TEMP\VKP038_2023-12-15.XML						C:\TEMP\KP038_2023-12-15.XML			Opslag
2	Resource	1005											8,55		3%
3	Valuta	EUR
4	Teller	38
5	Artikelcode	Zoekcode	Omschrijving	Status	Startdatum	Verkoopprijs	Verkoopprijs nieuw	Vkp + opslag	Kp +opslag	Kp +marge	Eenheid	Kostprijs	Kostprijs nieuw	Ikp +opslag%	Afwijking % Opslag	Inkoopprijs
6	100008	8712759037955	Vito Glaserfix 111 9x3 mm wit - 10x25 m	A	24/09/2019	30,61					pak	8,55			0,0000000%	8,30
Items

Cell Formulas
Range	Formula
B1	B1	=TODAY()
C1	C1	=TEXT("C:\TEMP\ART",0)&TEXT($B$4,"000")&"_"&TEXT($B$1,"JJJJ")&"-"&TEXT($B$1,"MM")&"-"&TEXT($B$1,"DD")&".XML"
F1	F1	=TEXT("C:\TEMP\VKP",0)&TEXT($B$4,"000")&"_"&TEXT($B$1,"JJJJ")&"-"&TEXT($B$1,"MM")&"-"&TEXT($B$1,"DD")&".XML"
L1	L1	=TEXT("C:\TEMP\KP",0)&TEXT($B$4,"000")&"_"&TEXT($B$1,"JJJJ")&"-"&TEXT($B$1,"MM")&"-"&TEXT($B$1,"DD")&".XML"
M2	M2	=(P6*$O$2)+P6
G6	G6	=IFERROR(IFS(J6>0,L6/(1-J6),I6>0,L6*(1*I6)+L6,H6>0,F6*(1*H6)+F6),"")
M6	M6	=IFERROR(IFS(N6>0,AN6*(1*N6)+AN6)/AU6,"")
O6	O6	=IFERROR(IFS(((P6*$O$2)+P6)-L6="0","ok",P6<>0,(100%-((L6*AU6/P6)))*-100%-$O$2),"")
P6	P6	=[@Inkoopprijs]

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
O6:O4980	Cell Value	contains "inkoopprijs"	text	NO
O6:O4980	Cell Value	not between -0,3% and 0,3%	text	NO
C6:C4980	Expression	=LEN(C6)>60	text	NO
B6:B4980	Cell Value	duplicates	text	NO

 

[arthurbr]

=IFERROR(IFS(((P6*$O$2)+P6)-L6="0"..
Without going any further, delete the double quotes around 0, they make it text instead of a number so
=IFERROR(IFS(((P6*$O$2)+P6)-L6=0 ....
( Don't know if that solves your problem though..)

 

[Romano_odK]

=IFERROR(IFS(((P6*$O$2)+P6)-L6="0"..
Without going any further, delete the double quotes around 0, they make it text instead of a number so
=IFERROR(IFS(((P6*$O$2)+P6)-L6=0 ....
( Don't know if that solves your problem though..)

Thank you but no it does not.

 

[Romano_odK]

If just found the problem myself.

 

[Peter_SSs]

@Romano_odK
If you have found a solution and would like to post the details, then it is fine to mark your own post as the solution. Otherwise, please do not mark a post that doesn't contain a solution. (I have removed the mark from post #3.)