Formula Help Please

[Thatguy99]

I would like a formula that returns the following and I am struggling.

We have 5 cells and in each cell we manually enter a figure. I would like to write a formula that returns the following in a 6th cell.

If any one of the 5 cells has a value greater than 1.59 then return "1" in cell 6. If any two cells return a value of greater than 1.59 then return a value of "2" in cell 6. So on until if all 5 cells return a value greater than 1.59 then return a value of "5" in cell 6.

It seems simple enough but I'm not sure how to write this formula.

Help would be greatly appreciated.

Thank you

[Arkadi]

Given A1 to A5 are the cells with values, put this formula in a cell:

Please Login or Register  to view this content.

[Jonmo1]

Try

=COUNTIF(A1:A5,">1.59")

[Arkadi]

Lol Jonmo1 great minds think alike?

[Thatguy99]

Perfect. Thank you both very much.

[Jonmo1]

You're welcome.

[FDibbins]

I know it has already been answered, but (for future reference)...please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.