98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Advanced
Excel Advanced
Resolved · Urgent Priority · Version 2007
Wed 26 Aug 2009, 11:05Delegate Tracy said...
Tracy has attended:
Excel Intermediate course
Excel Advanced course
Excel Advanced
How do i create a drop down box to enable me to do a If function?
Wed 26 Aug 2009, 19:43Trainer Amanda said...
RE: Excel Advanced
Hello Tracy
Thank you for your question.
Can you please explain a little more about what you would like to be able to do?
Kind regards
Amanda
Thu 27 Aug 2009, 09:17Delegate Tracy said...
RE: Excel Advanced
Hi Amanda,
I have an excel expense form that I want to use for company credit
card and personal cash. I have a column that is a Y/N company credit or
Personal cash.
I have at the bottom of the form two totals, CCC and personal cash. I need
the amounts that have Y(CCC) to be placed in the total for CCC and the
N (personal cash) to be placed in the PC row. I need to write a formula that will
Pick up the right columns.
Also I have written a formula to pick up the currencies used but can't seem to
Get the formulas to be fixed to the right cells.
I hope this is helpful to you assisting me
Regards
Tracy
Thu 27 Aug 2009, 13:55Trainer Amanda said...
RE: Excel Advanced
Hi Tracy
I think you need to use a Sumif from the sounds of what you have described, if I have understood your explanation then entries with a Y against them are CCC purchases; those with an N are personal cash purchases.
To use Sumif to total CCC purchases, enter =sumif(
Then select the range of cells that contain Y/N and type a comma in
Then enter "Y" followed by a comma
Then select the range of cells with the purchase amounts.
Do the same for PC, but using "N" instead of "Y"
The formula you have for the currencies, what does this formula do?
thanks
Amanda
Tue 1 Sep 2009, 08:44Delegate Tracy said...
RE: Excel Advanced
Morning Amanda,
I hope you have a lovely weekend. Thank you for answering my question. i was worried that i would be able to explain but you got it!
With regards to the currency formula, I need to it to calulate to eg Brazilan currency into GBP currency.
Regards
Tracy
Tue 1 Sep 2009, 13:31Trainer Amanda said...
RE: Excel Advanced
Hi Tracy
No problem, thank you for explaning your problem so clearly :)
I think you would need to do a multiplication - taking the Brazilian amount and multiplying (*) by the exchange rate to get GBP.
=Brazilian amount*conversion rate
Hope this helps?
Amanda
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Quick Absolute Cell ReferencesWhen entering cell references in a formula you probably click the cell, or you may type in the cell reference. If you require any of the 4 variations, press the F4 key now before you press Enter to toggle around the relative and absolute entries ($signs). |
