Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple algebra and excel
Okay so I have came accross another question regarding a simple
algebraic question. I am using a function like a1+a2+a3= when there are values in a1-3 excel places a 0 in the field which is ofcourse correct but I only want excel to populate the field if there is a positve or negative integer? Thanks for your help This discussion group rocks! Brandon |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple algebra and excel
Try an IF function: if (cell containing result) is 0, enter result,
otherwise enter nothing. wrote in message ups.com... Okay so I have came accross another question regarding a simple algebraic question. I am using a function like a1+a2+a3= when there are values in a1-3 excel places a 0 in the field which is ofcourse correct but I only want excel to populate the field if there is a positve or negative integer? Thanks for your help This discussion group rocks! Brandon |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple algebra and excel
Hi Brandon
Try the array entered formula {=SUM(IF(A1:A3=INT(A1:A3),A1:A3,0))} To commit or edit an array formula, use Control+Shift+Enter (CSE) not just Enter. Excel will insert the curly braces { } when you use CSE. Do not type them yourself. -- Regards Roger Govier wrote in message ups.com... Okay so I have came accross another question regarding a simple algebraic question. I am using a function like a1+a2+a3= when there are values in a1-3 excel places a 0 in the field which is ofcourse correct but I only want excel to populate the field if there is a positve or negative integer? Thanks for your help This discussion group rocks! Brandon |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple algebra and excel
On Mar 8, 8:50 am, "
wrote: I only want excel to populate the field if there is a positve or negative integer? I think you mean that you want Excel to __display__ only non-zero values. Two ways to accomplish that: =if(expression = 0, "", expression) Note that that requires the expression to evaluated twice :-(. Alternatively, create a custom format by clicking on Format - Cells - Number - Custom. Perhaps the following will meet your needs: general;-general; |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple algebra and excel
On Mar 8, 12:51 pm, "joeu2004" wrote:
On Mar 8, 8:50 am, " wrote: I only want excel to populate the field if there is a positve or negative integer? I think you mean that you want Excel to __display__ only non-zero values. Two ways to accomplish that: =if(expression = 0, "", expression) Note that that requires the expression to evaluated twice :-(. Alternatively, create a custom format by clicking on Format - Cells - Number - Custom. Perhaps the following will meet your needs: general;-general; okay so how do I compound that with the formula that I am using =g5+j5- k5 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple algebra and excel
Goto Tools ~ Options ~ View and unselect Zero Values (Office 2003)
" wrote: Okay so I have came accross another question regarding a simple algebraic question. I am using a function like a1+a2+a3= when there are values in a1-3 excel places a 0 in the field which is ofcourse correct but I only want excel to populate the field if there is a positve or negative integer? Thanks for your help This discussion group rocks! Brandon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Algebra graphic template | Excel Discussion (Misc queries) | |||
Algebra | Excel Worksheet Functions | |||
how do i write a Algebra formula in excel sheet | Excel Discussion (Misc queries) | |||
Algebra | Excel Worksheet Functions | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) |