Build flexible Excel functions that automatically handle blanks, defaults, and overrides without messy nested IFs.