Hello,

I am having trouble with some formulas displaying the results of the logical test as words.. For example.

=IF(E4>F4,100, IF(F4>E4, 200))

That works perfectly but I want "100" to be "Valid" and "200" to be "Invalid"

However...

=IF(E4>F4,Valid, IF(F4>E4, Invalid))

only results in the #NAME? error for me?

Any ideas?

Thanks !