Have attached a worksheet.

In the given worksheet, the cell AB2 should reduce if data is not
entered between N2:Y2. Basically the total scoring is out of 100. Cells
between N2 and Y2 have different weightages. Hence according to the cell
which is blank, ab2 should reduce the cell value.

Please help construct a formula for the same...


--
Sundaram Iyer
------------------------------------------------------------------------
Sundaram Iyer's Profile: http://www.excelforum.com/member.php...o&userid=23906
View this thread: http://www.excelforum.com/showthread...hreadid=375422