You are here:

# Excel/Excel formula query

Question
Hi, hope I can explain this without a diagram, but here goes. I'm looking for a forumal to assist my spreadsheet work.

Lets say,

In column A, line 1 I have a quoted figure of £100.

Then in column B line 1, I put the letter Y (for yes).

When I put the letter Y into that column I would like the quoted £100 to appear in column C.

If this is possible, I would also like it so that if I put a letter N (for no) into that cell (instead of Yes) then a standard  (never changing) total of £70.00 is added to column C.

I currently do have the latter set up, and the formula is placed in the C column (the totals column) and is this: - =if(a="N",70,0)

This means that when I answer N, I get £70 in the total column. So., Ideally I would like to get the quoted amount (which would be in column A, line 1) to be added to the totals column if the answer is Yes, and/or
the 70.0 added to to the totals if the answer is N.

Hope this makes sense!

I am using Excel 2003.

Hi Chris,

Thanks for sending your question on my way...

Please attach your file somewhere in the web for getting exact solution then attach the file in any of the below mentioned websites and send me the link.

Windows Live Skydrive: http://skydrive.live.com
MediaFire: http://www.mediafire.com
FileFactory: http://www.filefactory.com
FileSavr: http://www.filesavr.com
FileDropper: http://www.filedropper.com
RapidShare: http://www.rapidshare.com
Box.Net: http://www.box.net/files

--

Sixthsense
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

#### Sixthsense

##### Expertise

[Overview] Having hands-on experience with Excel, I can able to answer questions which is related to Conditional Formatting, Goal Seek, Scenarios, Subtotal, Validation, Pivot Table, Shared Workbook, Excel Sheet / Workbook Protection, Excel Settings, Excel Shortcuts and the Two Major & Massive Key Areas of Excel (i.e.) Worksheet Functions and Excel VBA (Macro).

[Services] Volunteer in many of the Excel Discussion Groups / Forums and answered more than 10,000+ questions (approx.)

[Client FAQs] My Solution Files

[Not Interested In] Chart Questions

[Something Controversial]