Excel 2007 : Formatting Equation for Income Recivable in A Certain Month

[eabushell]

First post - could really do with some help.

I have a spreadsheet set up in the following format:

Deal Size % % Deal Exp Date November December Janurary
£15,000 5% £750

What i need to do is the following:

In the expected date column I want to type the Month I expect the deal to come through;
In the month columns (i.e Nov, Dec, Jan) I want these to display the % deal sum (i.e. Deal Size * %)
I need each month column to correspond to the expected date only. Hence, I only want the % deal to show in the column on the month I expect to receive it.

I hope this explanation is not too convuluted.

Many thanks in advance for any help you maybe able to give me in determining the correct formula to use.

[NBVC]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Also, please adjust your title to be more specific about the question you are asking.

[eabushell]

How do I attach a dummy worksheet?

[NBVC]

Click Post Reply and then click the paperclip icon.

Click Browse and look for your document.

Click Upload and then close the window.

Also, change your title.

[eabushell]

See sheet attached.

[NBVC]

Maybe as simple as:

=IF($I2=J$1,$H2,"")

In J2 and copied across and down

[eabushell]

This is exactly what I needed NBVC. Thankyou so much for your kind help.

[NBVC]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save