ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Simple, Monday morning brain function (https://www.excelbanter.com/excel-worksheet-functions/6417-simple-monday-morning-brain-function.html)

craigwojo

Simple, Monday morning brain function
 

I can't seem to figure this out just yet but need an answer. Simple
percentage.

Column A: 60 (watts on a laser for an example)
Column B: 25 (watts on my laser)
Column C: 23% (speed on a 60 watt machine (Column A))
Column D: a figure for what speed I should set my machine - percentage
- to be in the right ratio of the 60 watts machine.

Thank you,
Craig


--
craigwojo
------------------------------------------------------------------------
craigwojo's Profile: http://www.excelforum.com/member.php...o&userid=13767
View this thread: http://www.excelforum.com/showthread...hreadid=278268


Alex Delamain


Surely -to be in the right ratio of the 60 watts machine- you should
also be at 23%
Or do you want to match output? In which case =A1*C1/B1


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=278268


Max

With A1: 60, B1: 25, C1: 23%
Try in D1: =(B1/A1)*C1
Format D1 as percentage
--
Rgds
Max
xl 97
--
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
---
"craigwojo" wrote in message
...

I can't seem to figure this out just yet but need an answer. Simple
percentage.

Column A: 60 (watts on a laser for an example)
Column B: 25 (watts on my laser)
Column C: 23% (speed on a 60 watt machine (Column A))
Column D: a figure for what speed I should set my machine - percentage
- to be in the right ratio of the 60 watts machine.

Thank you,
Craig


--
craigwojo
------------------------------------------------------------------------
craigwojo's Profile:

http://www.excelforum.com/member.php...o&userid=13767
View this thread: http://www.excelforum.com/showthread...hreadid=278268





All times are GMT +1. The time now is 07:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com