Formula "if" statement.

[asyamonique]

Good Day,
If "A1" cell value is "30" "A2" cell value will display as word of "Correct"
if "0" will be "Wrong" if nothing then it will be blank.
Is it possible to have a formula for the given sample?
Many Thanks

 

[Aladin Akyurek]

Good Day,
If "A1" cell value is "30" "A2" cell value will display as word of "Correct"
if "0" will be "Wrong" if nothing then it will be blank.
Is it possible to have a formula for the given sample?
Many Thanks

Try...

=IF(ISNUMBER(A1),
  IF(A1=0,"Wrong",IF(A1=30,"Correct","")),
  "")

 

[asyamonique]

Thanks,

 

[Aladin Akyurek]

Thanks,

You are welcome.