Question

errors value result when----------is wrong​

Answer 1

Answer:

Excel displays the #VALUE! error when a formula has the wrong type of argument.

Answer 2

Answer:

Remove spaces that cause #VALUE!

Select referenced cells. Find cells that your formula is referencing and select them. ...

Find and replace. ...

Replace spaces with nothing. ...

Replace or Replace all. ...

Turn on the filter. ...

Set the filter. ...

Select any unnamed checkboxes. ...

Select blank cells, and delete.

Hope it's helpful

Please mark me as brainliest

Follow me

Thanks my answers