what does @IF($K80,G8/$K8,0) mean in Lotus

January 14, 2011 at 10:49:17
Specs: Windows XP
I am trying to convert a formula from a lotus 123 cell to an excel cell. I don't know how to convert it to an excel formula.

See More: what does @IF($K80,G8/$K8,0) mean in Lotus

Report •

January 14, 2011 at 11:11:54
If $K80 is not 0, set the cell's value to G8 divided by $K8, otherwise set it to 0. I assume it's an attempt to avoid a #DIV/0! error, but it's testing the wrong cell.

How To Ask Questions The Smart Way

Report •
Related Solutions

Ask Question