Is there anyway to simply this formula?

[mailbox]

Here is the formula:
=IF(DI4>0,DM4,IF(DD4>0,DH4,IF(CY4>0,DC4,IF(CT4>0,CX4,IF(CO4>0,CS4,IF(CJ4>0,CN4,IF(CE4>0,CI4,IF(BZ4>0,CD4,IF(BU4>0,BY4,IF(BP4>0,BT4,IF(BK4>0,BO4,IF(BF4>0,BJ4,IF(BA4>0,BE4,IF(AV4>0,AZ4,IF(AQ4>0,AU4,IF(AL4>0,AP4,0))))))))))))))))

if possible, I would like to simplify it.

 

[fredlo2008]

I don't think so. I was looking at it and i couldn't find a single common item or pattern that would let us use AND or OR.

 

[Aladin Akyurek]

Here is the formula:
=IF(DI4>0,DM4,IF(DD4>0,DH4,IF(CY4>0,DC4,IF(CT4>0,CX4,IF(CO4>0,CS4,IF(CJ4>0,CN4,IF(CE4>0,CI4,IF(BZ4>0,CD4,IF(BU4>0,BY4,IF(BP4>0,BT4,IF(BK4>0,BO4,IF(BF4>0,BJ4,IF(BA4>0,BE4,IF(AV4>0,AZ4,IF(AQ4>0,AU4,IF(AL4>0,AP4,0))))))))))))))))

if possible, I would like to simplify it.

Does the order of IFs any sgnificance? Put otherwise, is the value which corresponds to any non-zero value ok?

 

[mailbox]

In the spreadsheet I am setting up a calculation based on if a section of data has been entered or not, the first if is the last piece of data, the last if is the first piece of data. So in order words, i believe the order is important.

 

[Aladin Akyurek]

In the spreadsheet I am setting up a calculation based on if a section of data has been entered or not, the first if is the last piece of data, the last if is the first piece of data. So in order words, i believe the order is important.

Is there more than one greater-than-zero cell at any time undergoing the IF test?

 

[hurgadion]

Hi,
try to reorganize Your Data if it is possible. Put Your Data e. g. to Columns A:B, to A1:B16 (You have 16 IF's in the Formula) exactly and try using the array Formula (Ctrl+Shift+Enter):

=IF(MIN(IF(A1:A16>0,ROW(A1:A16),""))=0,0,INDEX(B1:B16,MIN(IF(A1:A16>0,ROW(A1:A16),""))))

Best regards.