How to make 1=200%?

[Robbie]

I'm trying to do a spreadsheet for someone where they want to show the cost
including markup.

I have 3 fields
Cost(B2) Markup(C2) CPM(D2) (cost plus markup)

Then for example I have these values

..68, 2, $1.36

As you can see CPM is just Cost*Markup

However the person doesn't want it to say 2 he wants it to say 100%

Or similarly if I have another item that is
B3, C3, D3
..68, 1.75, $1.19 he'd want it to say 75%

I don't know how to do the math so it would work like he wants.

 

[JE McGimpsey]

One way:

D2: =B2 * (1+C2)

 

[Robbie]

Thanks using that formula I changed the value of my C column to 100% which
ends up looking like 1.00 or 75% .75

 

[Shane Devenshire]

Hi,

A different formula, but equivalent would be

=B2+B2*C2

 

[Engin Tarhan]

select the cells you want to be displayed in %, and format --> cells -->
Percentage

Good Luck
Engin Tarhan