| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 108814 | 2010-04-12 21:44:00 | Excel question | jcr1 (893) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 875846 | 2010-04-12 21:44:00 | How do I restrict the result, from formulae, to just the cell where the result is required? It looks untidy if the last result carries on down the column to the end of the formulae entered. Thanks. |
jcr1 (893) | ||
| 875847 | 2010-04-12 23:45:00 | I worked it out, Google is great:cool: Instead of this;" =SUM(E11-F11,G10) " I did this; " =IF(COUNT(E11:F11)>0,SUM(E11-F11,G10),"") " Works a treat. |
jcr1 (893) | ||
| 875848 | 2010-04-13 05:18:00 | Just an observation - you need to be careful with your data types when doing this - your formula is using IF logic to evaluate numbers, but your FALSE is actually adding an empty text string. Certain application will get cranky if they expect numbers, and you give them text. There is quite a difference between 0, "" and Is Null - learning about them can save you a lot of hassle down the line! :thumbs: |
nofam (9009) | ||
| 875849 | 2010-04-13 09:19:00 | Thanks nofam. Point taken. Would you have a better formula that would achieve what I want, rather than the implications inherent in the 2nd code? |
jcr1 (893) | ||
| 1 | |||||