Multiply depending on Term

Muthukrishnan V

Board Regular
Joined
May 29, 2008
Messages
164
Office Version
365
Platform
Windows
Office 365

Column C represents Term containing alphabet
either Q or H or Y or B or M

which denotes Q for quarterly; H for half-yearly;
Y for yearly; B for bi-monthly; and M for monthly.

Column D contains amount in numerical.

In column E, I want, for example if Cell C2 is Q,
and D2 is 792, result in E2 should be D2 x 4.
If C2 is H then D2 x 2.
If C2 is B then D2 x 6
If C2 is M then D2 x 12.

Kindly advise formula.
Thanking you,
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Watch MrExcel Video

Forum statistics

Threads
1,095,732
Messages
5,446,184
Members
405,390
Latest member
RafalKowalski

This Week's Hot Topics

Top