Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem | Excel Worksheet Functions | |||
Formula Problem | Excel Discussion (Misc queries) | |||
Formula problem | Excel Discussion (Misc queries) | |||
Formula problem | Excel Worksheet Functions | |||
Problem with formula | Excel Discussion (Misc queries) |