Subtract/divide answer/add in one cell
 

I'm sure this is simple to all, except this guy.

C:11 reveals 537

T:11 I need to preform from C:11
subtract 200, then divide by 12, then multiply by 1

Thank You

Subtract/divide answer/add in one cell
 

Try

=(C11-200)/12*1


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=502241

Subtract/divide answer/add in one cell
 

=(C11-200)/12

there is no point in multiplying by 1, it does nothing.

--

HTH

RP

"Pladdy" wrote in message
...
I'm sure this is simple to all, except this guy.

C:11 reveals 537

T:11 I need to preform from C:11
subtract 200, then divide by 12, then multiply by 1

Thank You