[users] little help with some numbers in calc.

Im working on updating some forms and Im having trouble with one of the cells. =IF(AT238-AT196=0,, AT238-AT196) If this cell has a value of 0 then print nothing, else, print the value. = IF(AU2381, 1) + IF(AV2381, 1) + IF(AW2381, 1) + IF(AX2381, 1) + IF(AY2381, 1) And then I have a column

Re: [users] little help with some numbers in calc.

On 6/18/2010 6:29 PM, Wade Smart wrote: Im working on updating some forms and Im having trouble with one of the cells. =IF(AT238-AT196=0,, AT238-AT196) If this cell has a value of 0 then print nothing, else, print the value. I would suggest familiarizing yourself with the help files in Open

Re: [users] little help with some numbers in calc.

Hi Wade, In a message dated 2010.06.18 18:29 -0500, Wade Smart wrote: Im working on updating some forms and Im having trouble with one of the cells. =IF(AT238-AT196=0,, AT238-AT196) If this cell has a value of 0 then print nothing, else, print the value. = IF(AU2381, 1) + IF(AV2381, 1) +

Re: [users] little help with some numbers in calc.

On 06/18/2010 06:29 PM, Wade Smart wrote: Im working on updating some forms and Im having trouble with one of the cells. =IF(AT238-AT196=0,, AT238-AT196) If this cell has a value of 0 then print nothing, else, print the value. = IF(AU2381, 1) + IF(AV2381, 1) + IF(AW2381, 1) + IF(AX2381,

Re: [users] little help with some numbers in calc.

Gene Young wrote: On 6/18/2010 6:29 PM, Wade Smart wrote: Im working on updating some forms and Im having trouble with one of the cells. =IF(AT238-AT196=0,, AT238-AT196) If this cell has a value of 0 then print nothing, else, print the value. I would suggest familiarizing yourself with the