Please solve

5 views
Skip to first unread message

Gaurav Sharma

unread,
Jun 6, 2018, 3:39:29 AM6/6/18
to excel...@googlegroups.com
Dear All friends,

I am sharing a query (attachment) and please help for me to solve this.



Thanks & Regards

Gaurav Sharma
closing stock details.xlsx

Praveen Dhiman

unread,
Jun 6, 2018, 4:31:18 AM6/6/18
to Gaurav Sharma, Excel Prince
Hi Gaurav,

Please find the solved file.


Thanks and Regards,

Praveen Kumar


--
You received this message because you are subscribed to the Google Groups "Excel Prince" group.
To unsubscribe from this group and stop receiving emails from it, send an email to excelprince+unsubscribe@googlegroups.com.
To post to this group, send email to excel...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/excelprince/CAPb7-mfM1PGfdE0Y2nzbNJ9Rd1wd0tg4WUeia3iRV8MfBvyE3Q%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

closing stock details (Praveen).xlsx

ExcelisMagic

unread,
Jun 6, 2018, 8:26:13 AM6/6/18
to Praveen Dhiman, Gaurav Sharma, Excel Prince
Hi Praveen,

PFA..... With formula.., =IF($D2<$E2,$E2-$D2,"") for positive value ,=IF($D2>$E2,$E2-$D2,"") for negative value Apply this formula.

Regards,
Mananjay Singh

Reply all
Reply to author
Forward
0 new messages