PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
Become a Premium Member and unlock a new, free course in leading technologies each month.
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
=IF(ABS(G2)=125,IF(ISERROR(LOOKUP(2,1/(ABS($G$1:G1)=125),($J$1:J1))),125*IF(G2<0,0.9,1.25),IF(LOOKUP(2,1/(ABS($G$1:G1)=125),($J$1:J1))*IF(G2<0,0.9,1.25)>1000,125,IF(LOOKUP(2,1/(ABS($G$1:G1)=125),($J$1:J1))*IF(G2<0,0.9,1.25)<25,50,LOOKUP(2,1/(ABS($G$1:G1)=125),($J$1:J1))*IF(G2<0,0.9,1.25)))),"")
Another approach.=IF(ISTEXT(O1),125*IF(N2<0,0.9,1.25),IF(O1*IF(N2<0,0.9,1.25)>1000,125,IF(O1*IF(N2<0,0.9,1.25)<25,50,O1*IF(N2<0,0.9,1.25))))
=IF(C1,IF(C1<0,D1*-0.9,D1+1.25),D1)
=IF(C1,IF(C1<0,D1*-0.9,D1+=IF(G1 >1000, 125, IF(G1<25, 50, G1))
=IF(G1 >1000, 125, IF(G1<25, 50, G1))
If you are experiencing a similar issue, please ask a related question
Join the community of 500,000 technology professionals and ask your questions.