If - Then question

K

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

T. Valko

Try this entered in D6:

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

Or:

Assuming N5 is a numeric value.

=(D20<>"U18")*N5
 
Top