ExcelBanter - Adding columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Adding columns - with tech info (https://www.excelbanter.com/excel-programming/307465-adding-columns-tech-info.html)

Katherine[_6_]

Adding columns - with tech info

I have this formula to get my database to idenify when
there is no information to calulatate in the cells but it
is not working - can you help? Thank you -- Katherine

=IF(countA(L30,M30,O30,P30)=0,0,(M30=O30,N(Q30)+N( N30)-1,N
(Q30)+N(N30))

Tom Ogilvy

Adding columns - with tech info

=IF(countA(L30,M30,O30,P30)=0,0,IF(M30=O30,N(Q30)+ N(N30)-1,N
(Q30)+N(N30)))

You left out the second IF statement.

--
Regards,
Tom Ogilvy

"Katherine" wrote in message
...
I have this formula to get my database to idenify when
there is no information to calulatate in the cells but it
is not working - can you help? Thank you -- Katherine

=IF(countA(L30,M30,O30,P30)=0,0,(M30=O30,N(Q30)+N( N30)-1,N
(Q30)+N(N30))

All times are GMT +1. The time now is 05:35 PM.