dezgimed Posted May 21, 2015 Report Share Posted May 21, 2015 Excel is driving me mental. Can someone please help me create an IF formula? I have several columns, however I need a formula that does the following: IF column x=0 AND column y>5 AND column z>69% then YES, if not all met then NO. Answers on a postcard! Link to comment Share on other sites More sharing options...
Peter O Hanraha-hanrahan Posted May 21, 2015 Report Share Posted May 21, 2015 42 Link to comment Share on other sites More sharing options...
dezgimed Posted May 21, 2015 Author Report Share Posted May 21, 2015 :laugh: move to Non Footy please Mods. Long day... Link to comment Share on other sites More sharing options...
Tom Fleuriot Posted May 21, 2015 Report Share Posted May 21, 2015 =IF(AND(B2=O,C2>5,D2>0.69),"YES","NO") Link to comment Share on other sites More sharing options...
bristolmoose Posted May 21, 2015 Report Share Posted May 21, 2015 =IF(AND(X1=0,Y1>5,Z1>69%), "Yes", "No") Link to comment Share on other sites More sharing options...
Southport Red Posted May 21, 2015 Report Share Posted May 21, 2015 What Moose said, except use commas where he put full stops EDIT: He DID put commas! HeadvTeavher's prophecy from long ago about things affecting my eyesight coming true!! Link to comment Share on other sites More sharing options...
Nibor Posted May 21, 2015 Report Share Posted May 21, 2015 =if(x1>0,if(y1>5,if(z1>69%,"YES","NO"),"NO"),"NO") Link to comment Share on other sites More sharing options...
bristolmoose Posted May 21, 2015 Report Share Posted May 21, 2015 You need to turn your resolution down or squint. They are commas. At least they were when I pasted them!! =IF(AND(X1=0,Y1>5,Z1>69%), "Yes", "No") Link to comment Share on other sites More sharing options...
bristolmoose Posted May 21, 2015 Report Share Posted May 21, 2015 Nibor's is the Flint version Link to comment Share on other sites More sharing options...
dezgimed Posted May 21, 2015 Author Report Share Posted May 21, 2015 You certainly get more helpful responses in this part of the forum.... Mods, please merge all forums. Thanks. Link to comment Share on other sites More sharing options...
BigTone Posted May 22, 2015 Report Share Posted May 22, 2015 It's a no from me Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.