Complex formulas in my excel spreadsheet

It is possible. We would need more information on your combination and pricing scheme however to provide more help.

Maybe 4 columns

Width, Height, Number of text lines, cost

with a formula in column D

=IF(C1=1,500,IF(C1=2,750,IF(C1=3,1000)))
Where 1, 2, 3 lines of text cost 500,750 and 1000
or if the cost of a text line is the same throughout then
the formula would be

=C1 * 500

if it was £500 a text line.

Invalid link?

Attachment is showing up bad on my end.

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Also, Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

deleted my duplicate post