The TRUE argument ignores any empty cells, saving you the hassle of manually filtering them out. Most people use IF ...

Plus: What do we make of Liam Lawson's performance so far? And we try to unpack the FIA's decisions around the race.

It uses the syntax: =IF(test, value_if_true, value_if_false) For more complex scenarios, Excel also offers the IFS function, ...

The Institute for Fiscal Studies (IFS) said this was mostly due to the Barnett Formula. It also found the Scottish government had used temporary coronavirus funding to pay for some permanent policies.