Share via

Eliminate #VALUE ! error message

Anonymous
2025-02-12T16:26:12+00:00

Hello,

I've been trying to figure out how to correct this formula to eliminate the error message #VALUE! in the cell that does have any source data linkec into the cell.

Basically cell F44 has source data because F44 displays (9). Cell F45 does have any source data and It's displaying #VALUE! and the source field does have any reliable data and most likely is blank. I would like to copy the correction over and int othe range F44, I44, L44, O44, Q44, U44, Y44, AA44, F45, I45, L45, O45.

Any help would be of greatly appreciated.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points
    2025-02-12T17:02:10+00:00

    You show the formula of F44 but not of F45. If it is similar, try something like

    =$C$45-IFERROR('1004_Grid_Download'!$J$24, 0)

    or

    =IFERROR($C$45-'1004_Grid_Download'!$J$24, 0)

    Was this answer helpful?

    0 comments