Whats wrong with my formula?

=IF($A$230=0,IF($A$230>1,IF($A$230,ISERROR,"ERROR ON SPREADSHEET"),"EMPTY SPREADSHEET"),"NO ERROR ON SPREADSHEET")

Formula is placed in A1
Currently when A230 is 0, A1 displays EMPTY SPREADSHEET,
Currently when A230 is greater than 1, A1 displays NO ERROR ON SPREADSHEET,
but when
A230 is an error, A1 shows #N/A instead of showing ERROR ON SPREADSHEET

How do I remedy this?

It would be helpful if you told us what you want to achieve and then we could change the formula

=IF($A$230=0,IF($A$230>1,IF($A$230,ISERROR,"ERROR ON SPREADSHEET"),"EMPTY SPREADSHEET"),"NO ERROR ON SPREADSHEET")

Formula is placed in A1
Currently when A230 is 0, A1 displays EMPTY SPREADSHEET,
It will do as a230=0 is true a230>1 ia false so you end up at the false value "ERROR on SPREADSHEET"

Currently when A230 is greater than 1, A1 displays NO ERROR ON SPREADSHEET,
A230=0 is false so goes straight to no error on spreedsheet at the end

but when
A230 is an error, A1 shows #N/A instead of showing ERROR ON SPREADSHEET


Perhaps if(iserror(a230),"error on spreadsheet",if(a230=0,"Empty Spreadsheet","No error on spreadsheet"))

but i do not know what is returned in a230, so this may need ammending
can A230 be negative is so what happens
can A230 be text if so what happens

Regards

Dav

Thanks, the alternative you gave works perfectly.