Hi,
I copied the formula in I10 but this warning comes up:
Warning.png
And when I press ok, the value in I10 is zero.
Hi,
I copied the formula in I10 but this warning comes up:
Warning.png
And when I press ok, the value in I10 is zero.
The formula should be entered in column J otherwise you would not be able to enter an AED value under the Unit Price without overwriting the formula.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Hi Nikamorphoses,
Based on the assumption that you enter in the quantities supplied in Col E and the "invoice" values from your suppliers in Cols F,J K and L (depending on the suppliers currency), then the attached should work.
Regards
peterrc
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks