Microsoft Excel gurus I need help!!!

[canny]

A part of my class project in Forestry I have to hazard rate a stand and project that rating for the next 95 years. I have build the worksheet but I'm having problems with the formula. An example is posted below, I need to findout how to calculate the Hazard Value based on the QMD and Basal Area.

Example: If the QMD is less than 7 and the Basal Area is less than 80, then the Hazard Value is "Low".

How do I get the Hazard value cell to reference both the QMD cell (A) and the Basal Area cell (B) and provide the correct value (C).

QMD Basal Area Hazard Rating

A B C


I'm sorry if this is confusing, Imagine how it is on my end lol

[WoJo]

You are going to have to do multiple caculations on multiple cells. Can you send me your spread sheat???

[baldybarton]

use if then statements, you can find them using the fx button next to the input line.

[canny]

I can send you a cut out portion of the sheet, cause the total sheet is 40 pages long
whats your email address?

[WoJo]

use if then statements, you can find them using the fx button next to the input line.

Baldy is right, you need to learn to use an IF statement. If x=<30 return 'low', IF x=30-60 return 'med', If x=60-100 return 'high'. It is not hard. You are almost there.

[canny]

oK I figured it out now I'm having a problem getting it to work. This is what I have currently, am I entering the proper format when I'm wanting something thats for example between 7 and 12.

=IF(AND(E4<6,F4<120),"Low",IF(AND(E4<6,F4>120),"Me d",IF(AND(6<E4>12,F4<80),"Low",IF(AND(6<E4>12,80<F 4>120),"Med",IF(AND(6<E4>12,F4>120),"High",IF(AND( E4>12,F4<80),"Low",IF(AND(E4>12,80<F4>120),"Med",I F(AND(E4>12,F4>120),"High","0"))))))))

[rhendrix]

Beat me to the punch, if then statements are awesome to use in Excel, if I stay in school I plan on taking a spreadsheet modeling class that really gets in-depth with Excel.

[WoJo]

You are getting there. Remember every ( has to have a ) and I see an extra spare or two.

[WoJo]

Should you do one more calculation before doing the IF statement???

[canny]

no cause the values that the if statement is referencing are numbers that have to be entered in manually.

Can you please point out the extra () because I checked all those and couldnt find any extra.

The problem i'm having now is the IF statements that are supposed to provide a value of "high". For some reason they only yield a value of "Med". All the other statements work like they are supposed to do i've ran several sets of numbers through them and the only ones that refuse to spit out the right answer are the "high" ones.

[WoJo]

=IF(AND(E4<6,F4<120),"Low"

If I put this into excel with 5 in E4 and 80 in F4 it returns false not Low.

How many ( do you see and ) do you see???

[WoJo]

Break it up into pieces and you will find your errors.

[WoJo]

So to make the above statement work you need

=IF(AND(E4<6,F4<120),"Low")

Just trying to help without seeing all of you data.