IF formula problem
Paul:
How about this formula: =IF(AND(J$24=$E27,J$24<=$F27),IF(OR(D1="Apples", D1= "Oranges"),E2,"Failed"),"Try Again") -- Marguerite "Paul" wrote: Hi all, Newbie question: I would like to add other attributes to a formula that i have and I'm not sure how to formulate but it would sound something like this: =IF(AND(J$24=$E27;J$24<=$F27);1;"") and IF D1= "Apple" or "Oranges" return value from D2 (ex:it woud be 75%) I do want to keep the AND(J$24=$E27;J$24<=$F27) as it's coupled with conditional formatting in my sheet. Thanks for your help! Paul Please help |
All times are GMT +1. The time now is 10:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com