How to return a value instead of TRUE/FALSE with IF,OR,AND statement

I am working on a nest of conditional IF statements containing OR & AND conditions and keep getting TRUE/FALSE instead of getting a value. Any ideas looking at my formula why I wouldn't be getting a value? If I run just one of the IF statements, I get a value, but when I start adding two or more, only TRUE/FALSE. Ideas?

=OR(IF(AND(B7=1,C7=1,D7>=1),1,IF(AND(B7=2,C7=1,D7=1),2,IF(AND(B7=3,C7=1,D7=1),4,IF(AND(B7=2,C7=1,D7=2),3,IF(AND(B7=3,C7>=2,D7>=1),5,IF(AND(B7=3,C7=1,D7>=2),5)))))))

Can you attach an example spreadsheet? That would help identify the issue. Thanks!

Is there another way to get the conditional value with multiple variables? Thanks

Just remove the OR.

=IF(AND(B7=1,C7=1,D7>=1),1,IF(AND(B7=2,C7=1,D7=1),2,IF(AND(B7=3,C7=1,D7=1),4,IF(AND(B7=2,C7=1,D7=2),3,IF(AND(B7=3,C7>=2,D7>=1),5,IF(AND(B7=3,C7=1,D7>=2),5))))))

What I am trying to achieve is this...

For three variable (F,P,D) there can be a value from 1-3 So for example F=2, P=2, D=1

Then I am taking those three data points and locating them on another chart that looks like

P
1 2 3
D 1 2 3 1 2 3 1 2 3
F 1 1 1 1 2 2 3 2 4 5
2 2 3 4 3 3 4 3 4 5
3 4 5 5 5 5 5 5 5 5

(Sorry I couldn't get a chart into this, but the P values are spread out over the D values where as P1 would cover D1,2,3, etc.)

So from the example above, the number would be 2

The subsequent value from this chart is then placed in a third and separate chart which is where my formula will be nested.

Ok... I feel officially dumb now... Thanks Jonmo1! Excel has a way of doing that very easily though

You're welcome.