Tick boxes & formulas HELP!!!

HELP!!

I am trying to work out a way to show/record the below

I need cell M6=10 if cell P6=1 & Q6 is TRUE or if P6=1 & Q6 is FALSE then M6=12

if P6=2 then M6=8 if Q6 is TRUE or if Q6 is FALSE then M6=10

I need this to go all the way up to P6=5

Is there a way to do this?

Thanks

try this formula in Cell M6:

Formula:

Please Login or Register  to view this content.

Thank you so much!

How do i go about changing the number in M6 if i want it to show 11 if the statement is TRUE or 9 if FALSE?

Much Appreciated








___________________________________________________________________________________________________
Many of life's failures are people who did not realize how close they were to success when they gave up.

try:

Formula:

Please Login or Register  to view this content.

Thank you again.

Could you please explain it to me as there are a few other outcomes I would like to see.

For example M6 if i want it to show 2 if the statement is TRUE or 0 if FALSE? and a range of other number combinations

It is a bit hard to explain this way (without an example workbook), but I'll try. I trust you are already aware that an IF Formula works like this: =IF(<Condition to Evaluate>,<Value if condition is True>,<Value if condition is False>)

So,

For example M6 if i want it to show 2 if the statement is TRUE or 0 if FALSE? and a range of other number combinations

would be formulated as:

Formula:

Please Login or Register  to view this content.

where Q6 is the cell being evaluated
2 if the condition/statement is TRUE, and
0 if the condition/statement is FALSE.

A good place to start with formulas is Excel Help. Please F1 & just type the name of a formula ("IF" in this case) to see how it works. Excel help also includes examples of formula usage that make it easy to follow.
Good luck