Hi all,
I have 5 columns, a description column 3 x columns with articles ordered in different currencies and a column with the total in British £. what I am trying to do is if an adjacent cell has a figure in it then the total cell will apply the relevant exchange rate to that amount and place the converted amount into the total cell but ignore the other adjacent empty cells. can this be done? thanks
J
Hi jser63 and welcome to the forum,
Assuming the costs are in B,C,D and exchanges rates (adjacent cells) are in F,G,H,...
Try this formula:
Please Login or Register to view this content.
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks