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.
|