if isserror then look to next column for 0 if 0 then give me 0 not working

[jordanburch]

Hi i have the above and i expect it to return a value of 0 as there is a zero there but its not. It does work when the 0 is on the right column. Any thoughts?
=+IF((ISERROR(AA6759)),IF(AB6759=0,0,IF(ISERROR(AB6759),IF(AA6759=0,0,"false"))))

 

[bobsan42]

You didn't specify what to return if AA6759 is NOT an error.

=IF(ISERROR(AA6759),
                      IF(AB6759=0,0,IF(ISERROR(AB6759),IF(AA6759=0,0,"false"))),
                      0)

 

[jordanburch]

You didn't specify what to return if AA6759 is NOT an error.

=IF(ISERROR(AA6759),
                                                            IF(AB6759=0,
                                                                                               0,
                                                                                                IF(ISERROR(AB6759),IF(AA6759=0,0,"false"))),
                                                             0)

ok thanks now when I insert that formula its just giving me 0 all around

went torow 6741

 

[bobsan42]

it's up to you what happens when the cells are blank or have any other value, i just explained why don't get a 0.

=IF(ISBLANK(AA6759),"",IF(ISERROR(AA6759),IF(AB6759=0,0,IF(ISERROR(AB6759),IF(AA6759=0,0,"false"))),0))

 

[jordanburch]

it's up to you what happens when the cells are blank or have any other value, i just explained why don't get a 0.

=IF(ISBLANK(AA6759),"",IF(ISERROR(AA6759),IF(AB6759=0,0,IF(ISERROR(AB6759),IF(AA6759=0,0,"false"))),0))

thats still giving me everything as 0. Basically just want if it is 0 in aa and ab return 0 if its value then false

 

[bobsan42]

=IF(ISBLANK(AA6759),"",IF(ISERROR(AA6759),IF(AB6759=0,0,IF(ISERROR(AB6759),IF(AA6759=0,0,"false"))),IF(AA6759=0,0,"false")))

 

[jordanburch]

=IF(ISBLANK(AA6759),"",IF(ISERROR(AA6759),IF(AB6759=0,0,IF(ISERROR(AB6759),IF(AA6759=0,0,"false"))),IF(AA6759=0,0,"false")))

worked thank you so much@!

 

[Alex Blakenburg]

I must be interpreting the logic differently:

20240323 If error and equals 0 vs null string jordanburch.xlsx
	AA	AB	AC	AD
1	AA	AB	Alex	bobsan42
2		#VALUE!	false
3	#VALUE!		false	0
4	0	#VALUE!	0	0
5	#VALUE!	0	0	0
6	0	0	0	0
7	5	#VALUE!	false	false
8	#VALUE!	5	false	FALSE
9	5	0	false	false
10	0	5	0	0
Sheet1

Cell Formulas
Range	Formula
AB2,AA8,AB7,AA5,AB4,AA3	AB2	=VALUE("X")
AC2:AC10	AC2	=IF(NOT(ISERROR(AA2)),IF(TRIM(AA2)="0",0,"false"),IF(NOT(ISERROR(AB2)),IF(TRIM(AB2)="0",0,"false")))
AD2:AD10	AD2	=IF(ISBLANK(AA2),"",IF(ISERROR(AA2),IF(AB2=0,0,IF(ISERROR(AB2),IF(AA2=0,0,"false"))),IF(AA2=0,0,"false")))

 

[jordanburch]

I must be interpreting the logic differently:

20240323 If error and equals 0 vs null string jordanburch.xlsx
	AA	AB	AC	AD
1	AA	AB	Alex	bobsan42
2		#VALUE!	false
3	#VALUE!		false	0
4	0	#VALUE!	0	0
5	#VALUE!	0	0	0
6	0	0	0	0
7	5	#VALUE!	false	false
8	#VALUE!	5	false	FALSE
9	5	0	false	false
10	0	5	0	0
Sheet1

Cell Formulas
Range	Formula
AB2,AA8,AB7,AA5,AB4,AA3	AB2	=VALUE("X")
AC2:AC10	AC2	=IF(NOT(ISERROR(AA2)),IF(TRIM(AA2)="0",0,"false"),IF(NOT(ISERROR(AB2)),IF(TRIM(AB2)="0",0,"false")))
AD2:AD10	AD2	=IF(ISBLANK(AA2),"",IF(ISERROR(AA2),IF(AB2=0,0,IF(ISERROR(AB2),IF(AA2=0,0,"false"))),IF(AA2=0,0,"false")))

Thanks looks good but I marked solution

 

[Alex Blakenburg]

It's giving different results, which one is right.