| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cutting out a process
Hi,
Am Mon, 2 Apr 2012 09:37:01 +0000 schrieb FooFighter616: Continuing on from this however, I now need to cut out a process. Currently I have this formula "=IF(L181<2400,$M$180*H181/$B$255,0)". The cell B255 contains the formula "=SUMIF(L$181:L$234,"<2400",$H$181:$H$234)". Basically, I want to cut out the cell B255 and have the whole thing in one formula. Is this possible and how would I do this? you have to replace $B$255 in the first formula with the formula into B255: =IF(L181<2400,$M$180*H181/SUMIF(L$181:L$234,"<2400",$H$181:$H$234),0) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ISBLANK function not working when cell is blank dut to function re | Excel Discussion (Misc queries) | |||
| Function not working | Excel Discussion (Misc queries) | |||
| UDF Function Not working | Excel Discussion (Misc queries) | |||
| Newly created Get Function is not working when I copied the syntax from a working function | Excel Programming | |||
| Working with Arrays, pasing from function to function | Excel Programming | |||
Threaded Mode
