• 466K Members
• 9,078 Online
• 563K Conversations

FORMULAS

Occasional Contributor

FORMULAS

I HAVE TO SPLIT G6 INTO D6 AND E6 I.E -600 AND -150 RESPECTIVELY , PLEASE HELP ME.
FILE ATTACHED

4 Replies

Re: FORMULAS

Hello @aayushman_mishra,

How is it determined that -600 goes into cell D6 and -150 goes into cell E6?

Re: FORMULAS

If logic is as here https://techcommunity.microsoft.com/t5/Excel/formula-for-data-calculation/m-p/804693, when in D6

``=IF( (B6-C6=-600) + (B6-C6=-750),-600,"")``

in E6

``=IF(AND(B6-C6>=-200,B6-C6<=-1),B6-C6,IF(B6-C6=-750,-150,""))``

and in G6

``=B6-C6-SUM(D6:F6)``

Re: FORMULAS

@PReagan hI, as per condition the discount amt not taken is -600 and the fine lies between -1 to -200 and re adm fee is -500. thats why we have to fix this formula.

Re: FORMULAS

@Sergei Baklan
Hello sir, as you told i applied the condition in E6
BUT AS I M EXTENDING THE FORMULA FOR MULTIPLE VALUES ITS SHOWING VALUE ERROR , PLEASE HELP ME REGARDING THIS, EXTENDED FORMULA IS MARKED GREEN.
I HAVE MULTIPLE 4 CONDITIONS THATS WHY I M EXTENDING THE FORMULA

 =IF(AND(B5-C5>=-200,B5-C5<=-1),B5-C5,IF(B5-C5=-750,-150,"")+IF(B5-C5=-650,-50,""))

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies