CODEWITHSUNDEEP
excel
P45 Imminent
P45 Imminent

Reputation: 8591

Function in Excel to return #VALUE

The Excel function =Na() returns #N/A.

Is there an equivalent function that returns #VALUE?

Obviously you could do something like =1*"" but is there something more satisfactory?

Upvotes: 0

Views: 59

Answers (1)

Steve
Steve

Reputation: 1638

There isn't really... but you can just use VALUE() as below

=VALUE("")

Upvotes: 1

Related Questions