#1   Report Post  
Sundaram Iyer
 
Posts: n/a
Default Problem with formula


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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Named SUM Formula with relative refernce(s) Werner Rohrmoser Excel Worksheet Functions 2 April 20th 05 04:56 PM
Simple formula doesn't quite add up circeo Excel Discussion (Misc queries) 3 January 17th 05 09:04 PM
Need a formula for this problem Trying to excel in life but need help Excel Worksheet Functions 1 January 12th 05 11:05 AM
Cell doesn't show formula result - it shows formula (CTRL + ' doe. o0o0o0o Excel Worksheet Functions 6 November 19th 04 03:13 PM
Excel 2003 - Formula result shows as 0:00 Serena Excel Worksheet Functions 4 November 11th 04 10:18 PM


All times are GMT +1. The time now is 03:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"