Multiple Conditions in a Formula

[wavmaster]

Can I use diferent criteria in an IF statement such OR

My formulas work great as written but I have 1 condition that causes the
formula to return the wrong result.
the solution for an earlier problem was to refference the formlas by
putting them in separate cells and simlifying my result to conply with true
or false and this solved the major issue =IF(C11<100,P2,Q2)
however another problem has arisen since the calculations are dependant on
other factors
once C11 reaches 100 if L5 is not = or > 500 the result is in error but the
formula in P2 still meets the criteria
I need to n=know how to make the following work
IF C11<100 & L5<500 then P2 because otherwise everything works as it should
the problem only persist when C11 is >- 100 and L5 is < 500

 

[Pete_UK]

What do you want to happen if L5 is greater than 500 when C11 is
greater than 100?

Pete

 

[wavmaster]

ok, if i may explain the desired result



C11 is the level and can be any number from 0 to infinity

L5 is the quantity of an object you can use and can be 1 through infinity



When C11 is any number below 100 you may use 5 of the items from L5 but no
more than 5xC11, if you do not sufficeint quantities in L5 you may use the
reserves that are built up in F15 and G15



F15 can be any quantity and G15 is limited to 8



the result is displayed in F2 so for the following F2 will have a maximum
value of 30



If C11=6, L5= 10, F15=2 & G15=8 then F2=20

like wise if C11=6, L5=30, F15=2 & G15=8 then F2=30

Basicly F2=C11*5 as long as C11<=100



Once C11=>100, F2 can only = 500+F15+G15 as long as L5=C11*5

the result for F2 in this case:



If C11=100, L5=520, F15=2 & G15=8 then F2=510

like wise if C11=100, L5=500, F15=2 & G15=8 then F2=510

but if C11=100, L5=400, F15=2 & G15=8 then F2=410