You are here:

- Home
- Computing/Technology
- Business Software
- Excel
- Excel formula query

Advertisement

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

Excel

Answers by Expert:

__ [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).

*50% of answers never been read by the questioner's.

*Only 5% of questioner's provide feedback about the suggested answers.

Vast Experience**Education/Credentials**

Ms-Office, Oracle, Foxpro, C, COBOL etc.,