Blake Ekelund
Excel
FP&A
Web Dev
Blog
Off the clock
Search
Ctrl K
Say hi
→
Loading...
IFZERO – Excel LAMBDA | Blake Ekelund
Excel Toolkit
›
IFZERO
IFZERO
Logic
Beginner
Replaces zero with a custom value.
LAMBDA(num, replacement, IF(num = 0, replacement, num))
Parameters
num
replacement
Example Usage
=IFZERO(A1, "N/A")
Pro Tips
Use VALUE() for safe numeric conversion
Common Issues
Non-numeric values will error