Hi
I'm kindly asking for a formula for column E, that if row B6 to B13 is deposit column E writes "Revenue" and if row B6 to B13 is withdrawal, column E writes "Expenses". See the attached excel.
Thank you.
Regards,
Sunboy
Hi
I'm kindly asking for a formula for column E, that if row B6 to B13 is deposit column E writes "Revenue" and if row B6 to B13 is withdrawal, column E writes "Expenses". See the attached excel.
Thank you.
Regards,
Sunboy
In E6 =IF(B6="Deposit","Revenue","Expenses") and copy down.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hi Alansidman
Thank you for the formula.
Regards,
Sunboy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks