Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula issue
I can't get this to work... {=SUM(((B5*(IF(Sheet!$A$2:$A$126=$A5,Sheet!$N$2:$N $126,0))/3600))/((IF(Sheet!$A$2:$A$126=$A5,Sheet!$M$2:$M$126,0)))) } The answer should be 5.452 but it's coming back #DIV/0 Please help!!! -- kelljeff ------------------------------------------------------------------------ kelljeff's Profile: http://www.excelforum.com/member.php...o&userid=32007 View this thread: http://www.excelforum.com/showthread...hreadid=529184 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula issue
your second if statement is returning a zero -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=529184 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula issue
I thought that too. But, When I pull it out and tried it alone it is returning a 5 which is correct. Also, If I add, subtract and multiply it works... only when I divide it returns the #DIV/0. -- kelljeff ------------------------------------------------------------------------ kelljeff's Profile: http://www.excelforum.com/member.php...o&userid=32007 View this thread: http://www.excelforum.com/showthread...hreadid=529184 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula issue
Any suggestions on a different formula -- kelljeff ------------------------------------------------------------------------ kelljeff's Profile: http://www.excelforum.com/member.php...o&userid=32007 View this thread: http://www.excelforum.com/showthread...hreadid=529184 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
imported impromtu report date issue - fix by format or formula | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
formula SUMIF or whichever one will work for my issue | Excel Worksheet Functions | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) |