Hi Experts,
Trying to use IF OR functions together for meeting 4 given criteria as follows
Criteria Last week sale This week sale Expected result of function
1Cirteria $0 $0 "Left"
2Cirteria $0 $1 100%
3Cirteria $1 $0 "Left"
4Cirteria $1 $2 (C5-B5)/B5
I use Function in cell is E3 is:
IF(OR(B2=0,C2=0,),"Left",IF(OR(B2>0,C2=0,),"Left",IF(OR(B2=0,C2>0,),100%,IF(OR(B2>0,C2>0,),(C2-B2)/B2%))))
No matter what changes are made in cell C2, B2 , result is "LEFT"
Thanks in advance
Karnik
Bookmarks