Variation on If Then Else Theme
 

Hi all,

Wondering if there's a way to change the values in two different cells
if condition is true...

I want the formula to look at a cell, say T36. If it is blank, "" or
null then S3 = S18 AND T3 = T18.

Is this possible?

cheers

DubboPete

Variation on If Then Else Theme
 

It's very simple.
In S3 you put the formula
=IF($T36="",S18,"whatever result you want if the condition isn't satisfied")
Copy to T3
--
David Biddulph

DubboPete wrote:
Hi all,

Wondering if there's a way to change the values in two different cells
if condition is true...

I want the formula to look at a cell, say T36. If it is blank, "" or
null then S3 = S18 AND T3 = T18.

Is this possible?

cheers

DubboPete

Variation on If Then Else Theme
 

On Apr 16, 3:58*pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
It's very simple.
In S3 you put the formula
=IF($T36="",S18,"whatever result you want if the condition isn't satisfied")
Copy to T3
--
David Biddulph



DubboPete wrote:
Hi all,

Wondering if there's a way to change the values in two different cells
if condition is true...

I want the formula to look at a cell, say T36. * If it is blank, "" or
null then S3 = S18 *AND *T3 = T18.

Is this possible?

cheers

DubboPete- Hide quoted text -

- Show quoted text -

Thanks David!