Is there a quick way to write a lengthy IF statement?

When Excel reads a statement that returns TRUE or FALSE, these values are interpreted by the formula as 1 or 0, respectively.

Therefore, these two statements return the same result:

=IF ( ISNUMBER (A1) , B1 , 0 )


This can be a useful trick to improve the readability and speed of writing some formulae.

#Formula #Excel #All

Recent Posts

See All

Frequently Asked Questions, by phone

I have a warning message When does it happen? Can you send a screenshot to us? Also, if you can, please email the PDF input document to us (or upload it using the 'File' menu within StatementReader) a

Message us or

Call us on +44 (0)20 3287 8283

Mon to Fri: 8am-8pm

Weekends: 10am-6pm