Excel

Hello,

What type of error are you experiencing in your spreadsheet? Check some of the list of possible errors in Excel

Green Triangle Error

In a situation where you're experiencing the green triangle top left of a cell as seen in cell B4 of the caption below, this implies that the value in cell B4 is stored as Text

To fix this kind of error:

select that cell B4, and click on the caution sign dropdown,

Select Convert to Number

 

#VALUE! Error

if you're getting #VALUE! error as seen in the caption below, that implies you've referenced one or more wrong cell. In the caption below, we multiplied cell C2 with the value 160 with cell A2 which has Phoebe Harding. This is bound to return #VALUE!

 

To fix that, in the formula bar or that particular cell, delete cell A2 and reference cell B2 as seen in the caption below

 

#NAME? Error

If you're getting #NAME? error as seen in the caption below, this is an indication that function name is incorrect. In the caption below, we used VLOOKU instead of VLOOKUP. That led to the error

To fix that, all we need to do is provide the correct function name which is VLOOKUP. See the solution below

#N/A Error

If you're getting #N/A error, this implies that wrong argument input value is provided. In the caption below, we see the #N/A error. This is as a result of cell B2 referenced as the input value for VLOOKUP lockup_value argument

To fix this provide, we reference cell A2. Problem fixed. See the caption below

Bobbie570 

If you mean colored triangle within the cell like

that's not actually an error but alert which informs that error could happen. You may expand drop-down menu and ignore or correct if that's a real error

It's also possible to switch-off all such alerts from the options

but I strongly do not recommend to do that.

 

If you have real error like #VALUE!, #N/A, etc - they are results of wrong calculations and without knowing how such calculations are performed it's hard to say something concrete.