Notifications
Clear all
General Excel Questions & Answers
4
Posts
2
Users
0
Reactions
89
Views
Topic starter
Hi everyone especially sir philip
i have a problem to separate the values of positive and negative into different cells of excel from cells of one column, for example there are some + or - values in column B:B, now i want the + value goes to cell 1 of column A and same as - values goes to cell 1 of column C, for more clearance i am sending attachment
Posted : 08/07/2020 4:47 am
Hi Salim,
You can use an IF statement - see attached.
In C20 you have
=IF(D19>0,D19,"")
and in E20 you have
=IF(D19<0,D19,"")
Regards
Phil
Posted : 08/07/2020 6:25 am
Topic starter
Dear Sir Philip
Thanks Sir
Posted : 09/07/2020 1:46 am
You're welcome Salim.
Posted : 09/07/2020 1:57 am
