Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
big formula?
I have a question about a formula:
cell AC7 has to have a formula that sound roughly like this: if P7 <=3 then 0 else if P7 4 but =15 then P7*(G7*0.05), if P7 =16 but <=30 then P7*(G7*0.06), if P7 =30 but <=365 then P7*(G7*0.07), P7 365 then P7*(G7*0.07). In all cases (but if P7<=3) the minimum value must be 3 I have tried all I knew (which isn't much) but without success.... any ideas? Thank again for any help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
big formula?
=IF(P7<3,0,MAX(IF(P7=30,IF(P7365,P7*G7*0.07,P7*G 7*0.07),IF(P716,P7*G7*0.0
6,IF(P7=15,P7*G7*0.05,"btwn 3 & <15"))),3)) Put in whatever calculation should be used for ,"btwn 3 & <15" or restated what the conditions are. -- Regards, Tom Ogilvy "antonov" wrote in message .. . I have a question about a formula: cell AC7 has to have a formula that sound roughly like this: if P7 <=3 then 0 else if P7 4 but =15 then P7*(G7*0.05), if P7 =16 but <=30 then P7*(G7*0.06), if P7 =30 but <=365 then P7*(G7*0.07), P7 365 then P7*(G7*0.07). In all cases (but if P7<=3) the minimum value must be 3 I have tried all I knew (which isn't much) but without success.... any ideas? Thank again for any help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
big formula?
try something like this with the higher numbers first. Chg e7 to p7 & f7 to
g7 =IF(E7365,0.08,IF(E729,0.07,IF(E715,0.06,IF(E7 2,0.05,0))))*F7 -- Don Guillett SalesAid Software "antonov" wrote in message .. . I have a question about a formula: cell AC7 has to have a formula that sound roughly like this: if P7 <=3 then 0 else if P7 4 but =15 then P7*(G7*0.05), if P7 =16 but <=30 then P7*(G7*0.06), if P7 =30 but <=365 then P7*(G7*0.07), P7 365 then P7*(G7*0.07). In all cases (but if P7<=3) the minimum value must be 3 I have tried all I knew (which isn't much) but without success.... any ideas? Thank again for any help |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
big formula?
I have tried both ways but I don't get the right results... guess I'm doing
something wrong "Tom Ogilvy" wrote in message ... =IF(P7<3,0,MAX(IF(P7=30,IF(P7365,P7*G7*0.07,P7*G 7*0.07),IF(P716,P7*G7*0.0 6,IF(P7=15,P7*G7*0.05,"btwn 3 & <15"))),3)) Put in whatever calculation should be used for ,"btwn 3 & <15" or restated what the conditions are. -- Regards, Tom Ogilvy "antonov" wrote in message .. . I have a question about a formula: cell AC7 has to have a formula that sound roughly like this: if P7 <=3 then 0 else if P7 4 but =15 then P7*(G7*0.05), if P7 =16 but <=30 then P7*(G7*0.06), if P7 =30 but <=365 then P7*(G7*0.07), P7 365 then P7*(G7*0.07). In all cases (but if P7<=3) the minimum value must be 3 I have tried all I knew (which isn't much) but without success.... any ideas? Thank again for any help |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
big formula?
Apparently.
-- Regards, Tom Ogilvy "antonov" wrote in message ... I have tried both ways but I don't get the right results... guess I'm doing something wrong "Tom Ogilvy" wrote in message ... =IF(P7<3,0,MAX(IF(P7=30,IF(P7365,P7*G7*0.07,P7*G 7*0.07),IF(P716,P7*G7*0.0 6,IF(P7=15,P7*G7*0.05,"btwn 3 & <15"))),3)) Put in whatever calculation should be used for ,"btwn 3 & <15" or restated what the conditions are. -- Regards, Tom Ogilvy "antonov" wrote in message .. . I have a question about a formula: cell AC7 has to have a formula that sound roughly like this: if P7 <=3 then 0 else if P7 4 but =15 then P7*(G7*0.05), if P7 =16 but <=30 then P7*(G7*0.06), if P7 =30 but <=365 then P7*(G7*0.07), P7 365 then P7*(G7*0.07). In all cases (but if P7<=3) the minimum value must be 3 I have tried all I knew (which isn't much) but without success.... any ideas? Thank again for any help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |