IF quick formula , please help

[bmarroush]

=IF(H7*I7>2,"Moderate"),IF(H7*I7>=5,"High", "Medium")

It is not calculating

Suggest correction

Thansks

 

[Gerald Higgins]

What do you mean "It is not calculating".

I imagine it IS calculating

If (H7*I7) = 6, for example, you might want it to show "High" but I think it will actually show "Moderate" because it meets the criteria for the first IF statement, so the second IF statement will not be evaluated.

What do you actually want this to do ?

 

[BarryL]

I think you mean :

=IF(H7*I7>2,"Moderate",IF(H7*I7>=5,"High","Medium"))

 

[Gerald Higgins]

BarryL - in what circumstances would the section
IF(H7*I7>=5
be evaluated ?

If H7*I7>=5, it will be dealt with by the first IF statement.

 

[bmarroush]

Thanks Barryl, ur right

You solved my issue and thanks for all who replied ,

Cheers