| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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)) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup info in one Column and then returning info in other columns | Excel Worksheet Functions | |||
| Macro to put info into certain columns based on info in another co | Excel Discussion (Misc queries) | |||
| matching two columns and adding info | Excel Discussion (Misc queries) | |||
| TECH SUPPORT NUMBERS | New Users to Excel | |||
| High Tech Question ? | Excel Programming | |||
![Katherine[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
