big formula?

A

antonov

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
 
T

Tom Ogilvy

=IF(P7<3,0,MAX(IF(P7>=30,IF(P7>365,P7*G7*0.07,P7*G7*0.07),IF(P7>16,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.
 
D

Don Guillett

try something like this with the higher numbers first. Chg e7 to p7 & f7 to
g7
=IF(E7>365,0.08,IF(E7>29,0.07,IF(E7>15,0.06,IF(E7>2,0.05,0))))*F7
 
A

antonov

I have tried both ways but I don't get the right results... guess I'm doing
something wrong
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

averages with formulas 5
IF formula help - incorporate greater than & smaller than 10
How do I display 0 if it is the end result for a formula 4
Quick VBA Worksheet Change Event or Selection Question: 6
Quick VBA Worksheet Change Event or Selection Question: 1
How to use time in an IF formula 8
Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA) 7
Nesting IF funtions 2

Top