Count if a number in a cell
 

I'm looking a way to count or subtract two numbers if any on cells , if
there is a number, or 0, in a different cell.

N7 is the cell for the formula,
H7 the one if number found then
subtract L7-H7, but if there is no number on
L7, just show the same number of H7 on N7.

Any hint will be helpful...

Count if a number in a cell
 

Hi
Try
=IF(L7="",H7,H7-L7)

--
Regards
Roger Govier

"JC-PS" wrote in message
...
I'm looking a way to count or subtract two numbers if any on cells , if
there is a number, or 0, in a different cell.

N7 is the cell for the formula,
H7 the one if number found then
subtract L7-H7, but if there is no number on
L7, just show the same number of H7 on N7.

Any hint will be helpful...

Count if a number in a cell
 

Doesn't =H7-L7 do just that?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi
Try
=IF(L7="",H7,H7-L7)

--
Regards
Roger Govier

"JC-PS" wrote in message
...
I'm looking a way to count or subtract two numbers if any on cells ,
if
there is a number, or 0, in a different cell.

N7 is the cell for the formula,
H7 the one if number found then
subtract L7-H7, but if there is no number on
L7, just show the same number of H7 on N7.

Any hint will be helpful...

Count if a number in a cell
 

"Bob Phillips" wrote:

Doesn't =H7-L7 do just that?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi
Try
=IF(L7="",H7,H7-L7)

--
Regards
Roger Govier

"JC-PS" wrote in message
...
I'm looking a way to count or subtract two numbers if any on cells ,
if
there is a number, or 0, in a different cell.

N7 is the cell for the formula,
H7 the one if number found then
subtract L7-H7, but if there is no number on
L7, just show the same number of H7 on N7.

Any hint will be helpful...



Thank you. Up to the moment I'm trying with
=IF(H7<0,L7+H7,"-") somehow fine
and doing the work. But got problems on next step as I'll describe
hereafter.
M7 "=IF(L7="",H7,H7-L7)" is working perfectly. Now under the results of M7 or on M8, & using the previous example, multiply it by D2*2
when
M7 is negative and results should end up on positive value because of
Total column. I tried with =IF(M7="",-M7*D2*2) but no so good.
M8 if neg=M7*D2*2 but in absolute value. Any help :D

Count if a number in a cell
 

"JC-PS" wrote:



"Bob Phillips" wrote:

Doesn't =H7-L7 do just that?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi
Try
=IF(L7="",H7,H7-L7)

--
Regards
Roger Govier

"JC-PS" wrote in message
...
I'm looking a way to count or subtract two numbers if any on cells ,
if
there is a number, or 0, in a different cell.

N7 is the cell for the formula,
H7 the one if number found then
subtract L7-H7, but if there is no number on
L7, just show the same number of H7 on N7.

Any hint will be helpful...



Thank you. Up to the moment I'm trying with
=IF(H7<0,L7+H7,"-") somehow fine
and doing the work. But got problems on next step as I'll describe
hereafter.
M7 "=IF(L7="",H7,H7-L7)" is working perfectly. Now under the
results of M7 or on M8, & using the previous example, multiply it by
D2*2 when
M7 is negative and results should end up on positive value because
of Total column. I tried with =IF(M7="",-M7*D2*2) but no so good.
M8 if neg=M7*D2*2 but in absolute value. By the way, up to
a previous moment I was weighing up with the next,
=IF(M7<0,-M7*D2*2,"")... any better suggestion.

Count if a number in a cell
 

=IF(L8="",G8<0,IF(M7<0,-M7*D2*2,L8)) any how working better
even when M7 is a negative or a positive number, incl 0. ;D

Count if a number in a cell
 

"JC-PS" wrote:


=IF(L8="",G8<0,IF(M7<0,-M7*D2*2,L8)) any how working better
even when M7 is a negative or a positive number, incl 0. ;D
A correction,
=IF(L8="",G8<0,IF(G7<0,G7*D2*2,L8)), much better :D