Hi there genius
I realy hope that someone can help me solving this huge problem. For you, probably a little challenge
Im gonna make a Excel form that generates 5 different invoices at the same time by writing some information in the first page.
First page = Forside
Second page = Faktura 1 and so on.
Forside and Faktura 1 is ok, but what I need is the IF function in G14 (Faktura 2, 3, 4 and 5) to subtract 10% of the value in E12 or E16 - 20 (Forside) until it has reached the same value as in B12 (forside).
So if it reach the value in Faktura 3, than it wont subtract anything in 4 and 5. And also if the value to be subtract is less than 10% to reach the value in E12 (Forside), it has to subtract as much as it need to reach the value of E12 (Forside).
Hope that that somebody can help me solve this, and that I explained it god enough.
Excel file attached.
Best regards
Øystein Breivik
Bookmarks