would like to add an IFERROR to a simple formula, can't seem to get it to work
Hi,
I have a simple formula I am using in one of my sheets to calculate a percentage:
=[Training/90 day complete]@row / FDS@row
I would like to amend it so that if the cell in the Training/90day complete column is blank, to leave it blank rather than calculating it and returning 0%.
How would I do that?
Thanks in advance!
Emily
Tags:
Answers
-
@Emily Sanchez Here is what I would use:
=IFERROR(IF(ISBLANK([Training/90day complete]@row), "", ([Training/90day complete]@row / FDS@row)), "")
ISBLANK should catch the condition where Training/90day is blank
IFERROR should catch the condition where FDS is blank.
(seems to work in North America)
dm
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!