| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple One
Hello I want to add column A and column B, but if the total is zero I do
not want the zero to show, I tried =if(a2+a3=0), " ",)a2+a2) .. but it is obviously wrong thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple One
=IF(A1+B1=0,"",A1+B1) "Wanna Learn" wrote: Hello I want to add column A and column B, but if the total is zero I do not want the zero to show, I tried =if(a2+a3=0), " ",)a2+a2) .. but it is obviously wrong thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple One
contents of C2 will be the following, and display the sum of the
adjacent cells in column A with column B. =if(A2*B2, A2+B2,"") Not sure what you were doing adding up rows. A2 + A3 is row addition. Wanna Learn wrote: Hello I want to add column A and column B, but if the total is zero I do not want the zero to show, I tried =if(a2+a3=0), " ",)a2+a2) .. but it is obviously wrong thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple One
The OP asked for the zero not to show if the TOTAL is zero, not if the
PRODUCT is zero, so you could change that to =if(A2+B2, A2+B2,"") -- David Biddulph "Bob I" wrote in message ... contents of C2 will be the following, and display the sum of the adjacent cells in column A with column B. =if(A2*B2, A2+B2,"") Not sure what you were doing adding up rows. A2 + A3 is row addition. Wanna Learn wrote: Hello I want to add column A and column B, but if the total is zero I do not want the zero to show, I tried =if(a2+a3=0), " ",)a2+a2) .. but it is obviously wrong thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple One
Thank you for the correction, I transposed the request.
David Biddulph wrote: The OP asked for the zero not to show if the TOTAL is zero, not if the PRODUCT is zero, so you could change that to =if(A2+B2, A2+B2,"") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| maybe by another more simple way | Excel Discussion (Misc queries) | |||
| Simple lookup - or maybe not so simple - help! | Excel Worksheet Functions | |||
| Please help. Very simple but I don't know. :) | Excel Worksheet Functions | |||
| Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
| Make it more simple or intuitive to do simple things | Charts and Charting in Excel | |||
Hybrid Mode
