ExcelBanter - How this function S=( P*47/7-P) in Exel work

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How this function S=( P*47/7-P) in Exel work (https://www.excelbanter.com/excel-programming/357198-how-function-s%3D-p%2A47-7-p-exel-work.html)

mohammad

How this function S=( P*47/7-P) in Exel work

Example:cell P=1.75. Cell S=(1.75*47/7-1.75) ,How can this be formulated to
work for all the cells in the culumS?

davesexcel[_83_]

How this function S=( P*47/7-P) in Exel work

=P1*47/7-P1
you can paste this formula in S1 and then copy it down the column

--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=526615

All times are GMT +1. The time now is 03:07 PM.