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?
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
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
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
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
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
