Condition 1 IF $O2<$M2 AND (J2*(1-$V$2)<P2), then $V$2
Condition2 IF $O2<$M2 AND (J2*(1-$V$2)>P2), then $N2-K2
Condition 3 IF $O2>$M2, then $N2-J2 unless $N2-J2 < 0, then 0)
Được trao cho:
Hello, this is very simple, this is nested IF statement. If you like feel free to message me, and i will combine this for you in matter of minutes. Thanks, Milan
15 freelancer chào giá trung bình$18 cho công việc này
Hi Sir, I can complete this simple formula within 30 mins. Please ping back with the workbook. I have 10+ years of experience. Please check my past reviews. Thank You Regards Rishi
I can perfectly combine all these conditions into a single formula. I am a professional Excel expert holding years of experience. I will be happy to discuss in detail.
Hi I am an expert in Excel and VBA application. I can help you with this task fast and accurate. Contact me now to discuss and I will start right away. Regards!
Hi there! I'm very conversant with excel formulas and functions, and I'll create a formula that gives the desired output as you've stated. Let's discuss more via chat. Thanks!
Hi, I have read your job description and I think I am a perfect fit for your project. I can provide you with best results in no time. Inbox me to discuss further about it. Kind Regards Nazmul
Hi, I have good knowledge and experience in Microsoft excel and this project is purely excel formula so it is not a hard task for me to do in one or two days.