Does any one have any ideas:
I'm a graphic designer and i'm trying to build a spreadsheet that will help me in doing my accounts.
Ok, so i'm trying to set up a function that will generate a price based on three fields:
Lamination:YES or NO
Duplex: YES or NO
Stock: Around 14 different stock options.
I had it working using a nested IF but I ran out of the 7.
I then tried using CONCATENATE using "&" to seperate but excel said the formula was too long.
I'm Lost!
Bookmarks