If - Then question

[Ksean]

How would I write a formula to handle this problem?
If the value in cell D20 is ‘U18’ then the result in cell D6 is a ‘0’
however if the value in D20 is anything else then the result in cell D6 is
the value in N5

 

[T. Valko]

Try this entered in D6:

=IF(D20="U18",0,N5)

Or:

Assuming N5 is a numeric value.

=(D20<>"U18")*N5

 

[Ksean]

I went with your second option and it worked great!

Thanks.

 

[T. Valko]

You're welcome. Thanks for the feedback!