In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.
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.