Combination of formulas, if, and, or
 

How do i do this?
I want the formula in a47 to check if theres something (a number) in j47 and
in j49. If so, the formula must take these two numbers and subtract from a47,
but if (j47+j49) a47, then the rest should subtract the number in b47.
Maybe it will be easier to make two different formulas, one in a47 and one
in b47.

I'll appreciate any help! Thank you!

Regards Unni

Combination of formulas, if, and, or
 

If you put a formula in A47 that subtracts from A47, then you've got a
circular reference, but if you want to put a formula somewhere else, it
sounds like:

=IF(AND(ISNUMBER(J47),ISNUMBER(J49)),IF(J47+J49A4 7,A47-(J47+J49)-B47,A47-(J47+J49)),"")

(assuming that when you say "subtract the number in b47", you mean subtract
B47 from what the formula would otherwise have given).
--
David Biddulph

"Unni" wrote in message
...
How do i do this?
I want the formula in a47 to check if theres something (a number) in j47
and
in j49. If so, the formula must take these two numbers and subtract from
a47,
but if (j47+j49) a47, then the rest should subtract the number in b47.
Maybe it will be easier to make two different formulas, one in a47 and one
in b47.

I'll appreciate any help! Thank you!

Regards Unni