ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   big formula? (https://www.excelbanter.com/excel-programming/347558-big-formula.html)

Antonov

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



Tom Ogilvy

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





Don Guillett[_4_]

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




Antonov

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







Tom Ogilvy

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










All times are GMT +1. The time now is 10:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com