IF(and formula with 3 conditions

February 6, 2012 at 04:04:06
Specs: Windows 7 Home Premium (x64) Ser2.67gigahertz, vice Pack 1 (build 7601), 2.67 GHz Intel Core2 Duo / 6 gigs
=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?

See More: IF(and formula with 3 conditions

Report •

February 6, 2012 at 08:30:43
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.

Report •
Related Solutions

Ask Question