IF Statement

[EvansB2]

I'm running the following formula:

IF(D7="building one","A","B")

thus the output being an A or B in the next column (column E)

However, when copied the formula down it gives the B result in the all the cells and makes the spreadsheet untidy.

How can I take account of this? i.e. when column D is blank then column E needs to be blank

Would appreciate some help

Ben

 

[Aladin Akyurek]

I'm running the following formula:

IF(D7="building one","A","B")

thus the output being an A or B in the next column (column E)

However, when copied the formula down it gives the B result in the all the cells and makes the spreadsheet untidy.

How can I take account of this? i.e. when column D is blank then column E needs to be blank

Would appreciate some help

Ben

Try...

=IF(D7="","",IF(D7="building one","A","B"))

 

[EvansB2]

Thanks. All working good.

 

[Aladin Akyurek]

Thanks. All working good.

You are welcome. Thanks for providing feedback.