would like to add an IFERROR to a simple formula, can't seem to get it to work

Emily Sanchez

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

Dale Murphy

@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