If Statement

[jigsaw1980]

Hi There,

I am having trouble with an If statement and getting it to do what I need.

Basically I want 4 cells populated with different values if a cell on a different sheet is not blank.

If the cell on the previous sheet is blank, then I dont want the cells populated.

Is this possible?

Thanks,
Mark

 

[NBVC]

I am sure it's possible, but it would be good if we had more details concerning what the conditions are, and how/where to be found in other sheets, etc...

 

[CazB]

First stab (without further info )

In Each cell that you want populated, you need to use something like
=If (Cell to check, Value to display if it's NOT empty, Value to display if it IS Empty)

eg

=if(sheet1!C2,"Hello","")

=if(sheet1!C2,A1*b2,"")

 

[jigsaw1980]

Thanks NVBC.

Basically Ive included shots of the 2 sheets Im talking about. If the box highlighted on sheet 1 is populated then I want the 4 cells on sheet 2 to be populated.

If not then I want them empty

Its an optional field on an XML Message I am trying to create via Excel.

 

[NBVC]

Ok,

In column A of Sheet2 enter:

=IF('MPRN_LevelInformation!$B$12="","",'MPRN_LevelInformation!A$12)

and copy across the 4 columns...

 

[jigsaw1980]

Hi NBVC,

Im getting an error with that formula. Any ideas?

Thanks.
Mark

 

[NBVC]

try:

=IF('MPRN_LevelInformation'!$B$12="","",'MPRN_Level Information'!A$12)

 

[jigsaw1980]

Works Perfectly Dude.

Thanks a million