Excel 'IF' Help

[marsbar]

Cell DM6 picks up info from another spreadsheet and enters a value. Cell DI6 contains a date that could be changed to "Did not play". Is there a formula that would replace DM6 with zero when "Did not play" is entered into DI6 but keep the info from the other sheet when Did not play is not entered?

 

[Nebu]

Hi:

Use the following formula

=IF(DI6="Did not play",0,'Scratch to Comp.xlsx12'!$I$20)

Thanks

 

[marsbar]

Hi:

Use the following formula

=IF(DI6="Did not play",0,'Scratch to Comp.xlsx12'!$I$20)

Thanks

Thanks for the reply. Worked a treat. I had it the wrong way round but just couldn't see it.