=if(h4772>=.10, h4771>=.10,1,if(and(h4772>=.5,if(and(h4771>=.5, h4770>.5,1)))),0) The condition places "1" in the cell if(h4772>=.10, h4771>=.10,1

But, if h4772>.5 and h4771>.5 and h4770>.5 placing a "1" in the cell is also desired, but this part of the equation does not work properly.How should the formula be written?

First, I'm pretty sure that the formula you have posted is not what you are using in your spreadsheet. I say this for 2 reasons: 1 - If it were copied directly from your spreadsheet, everything would be capitalized.

2 - When I paste your formula into a spreadsheet it produces an error.Please copy the formula directly from the formula bar and paste it into your post.

I won't even go into the other issues with your formula, since, as posted, it can't possibly return a "1" until the errors are eliminated so that Excel can evaluate it.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Would you use "Spotlight Search" on Windows?

Discuss in The Lounge

Poll History