Prev: How to convert text "JAN" into number 1?
Next: I need to link 4 pivot tables that are on a single page.
From: Peter on 10 Apr 2010 10:19
Good afternoon,

I have been attempting to create a formula to do the following:

In three columns: B, C & H. If B3 & C3 do not contain a value I want to H3 to also be
blank despite H2 containing a figure.
However, if B2 and or C2 contain a figure, I wish to display the result - if this makes sense!
The existing formula in H3 is: =H2+C3-B3 and I've been trying to create the appropriate
formula without success.

What am I doing wrong?

Regards

Peter

From: Gary''s Student on 10 Apr 2010 11:02
=IF(B3 & C3="","",H2+C3-B3)

--
Gary''s Student - gsnu201001


"Peter" wrote:

> Good afternoon,
>
> I have been attempting to create a formula to do the following:
>
> In three columns: B, C & H. If B3 & C3 do not contain a value I want to H3 to also be
> blank despite H2 containing a figure.
> However, if B2 and or C2 contain a figure, I wish to display the result - if this makes sense!
> The existing formula in H3 is: =H2+C3-B3 and I've been trying to create the appropriate
> formula without success.
>
> What am I doing wrong?
>
> Regards
>
> Peter
>
> .
>
From: Peter on 11 Apr 2010 08:00
On 10/04/2010 16:02, Gary''s Student wrote:
> =IF(B3& C3="","",H2+C3-B3)
>
Many thanks Gary''s Student - it works a treat, I was trying to use OR!
The next question is when either B3 or C3 contain a number, how do I change the font
colour of H3 to say, white?
Kind regards

 | 
Pages: 1
Prev: How to convert text "JAN" into number 1?
Next: I need to link 4 pivot tables that are on a single page.