Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can this be made smaller?
((c4=0)*((e10*1.4)+(e11*1.25)+(e12*0.5)+(e13*0.5)) ) -- fivermsg ------------------------------------------------------------------------ fivermsg's Profile: http://www.excelforum.com/member.php...o&userid=32348 View this thread: http://www.excelforum.com/showthread...hreadid=522608 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
can this be made smaller?
=(C4=0)*SUMPRODUCT(E10:E13,{1.4;1.25;0.5;0.5})
-- Regards, Tom Ogilvy "fivermsg" wrote: ((c4=0)*((e10*1.4)+(e11*1.25)+(e12*0.5)+(e13*0.5)) ) -- fivermsg ------------------------------------------------------------------------ fivermsg's Profile: http://www.excelforum.com/member.php...o&userid=32348 View this thread: http://www.excelforum.com/showthread...hreadid=522608 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
can this be made smaller?
one more.. any takers for this? if possible. ((C2=1)*(E8*2)*(0.7)+(C2=2)*(E8*1.8)*(0.7)+(C2=3)* (E8*1.65)*(0.7)+(C2=4)*(E8*1.6)*(0.7)) i have quite a large formula and it is now tell me it is to long so i am just trying to find some place -- fivermsg ------------------------------------------------------------------------ fivermsg's Profile: http://www.excelforum.com/member.php...o&userid=32348 View this thread: http://www.excelforum.com/showthread...hreadid=522608 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
can this be made smaller?
repost message -- fivermsg ------------------------------------------------------------------------ fivermsg's Profile: http://www.excelforum.com/member.php...o&userid=32348 View this thread: http://www.excelforum.com/showthread...hreadid=522608 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
can this be made smaller?
repost message -- fivermsg ------------------------------------------------------------------------ fivermsg's Profile: http://www.excelforum.com/member.php...o&userid=32348 View this thread: http://www.excelforum.com/showthread...hreadid=522608 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can this be made smaller? | Excel Discussion (Misc queries) | |||
divide a large group of people into smaller groups by their vote | Excel Discussion (Misc queries) | |||
How can I get a report on the number of field changes made in Exce | Excel Discussion (Misc queries) | |||
Save prompt when no changes made | Excel Discussion (Misc queries) | |||
3-D refrence made easy? Please help me out! | Excel Discussion (Misc queries) |