ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I set up a formula in excel? (https://www.excelbanter.com/new-users-excel/4872-how-do-i-set-up-formula-excel.html)

wiskeyjruiz

How do I set up a formula in excel?
 
I need help to set up a formula on Excel Worksheet.
Exsample: I need to Subtract cell A8 from A7; then Mutiply it by "24."
But I need this formula on cell C8. Can I get some help with this problem?

Don Guillett

Just simple logic. In c8
=(a7-a8)*24

--
Don Guillett
SalesAid Software

"wiskeyjruiz" wrote in message
...
I need help to set up a formula on Excel Worksheet.
Exsample: I need to Subtract cell A8 from A7; then Mutiply it by "24."
But I need this formula on cell C8. Can I get some help with this problem?




RagDyeR

It's exactly the same type of answer as in your other post.
Just replace the data with what you're asking here.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"wiskeyjruiz" wrote in message
...
I need help to set up a formula on Excel Worksheet.
Exsample: I need to Subtract cell A8 from A7; then Mutiply it by "24."
But I need this formula on cell C8. Can I get some help with this problem?



wiskeyjruiz

Thanks. The thing is , when I tryi to copy the same formula on the same row
going down, im trying to have the same formula but without the cells showing
"0" on the cells.

"Don Guillett" wrote:

Just simple logic. In c8
=(a7-a8)*24

--
Don Guillett
SalesAid Software

"wiskeyjruiz" wrote in message
...
I need help to set up a formula on Excel Worksheet.
Exsample: I need to Subtract cell A8 from A7; then Mutiply it by "24."
But I need this formula on cell C8. Can I get some help with this problem?





Don Guillett

if(myformula=0,"",myformula)
or
toolsoptionsviewzeros

--
Don Guillett
SalesAid Software

"wiskeyjruiz" wrote in message
...
Thanks. The thing is , when I tryi to copy the same formula on the same

row
going down, im trying to have the same formula but without the cells

showing
"0" on the cells.

"Don Guillett" wrote:

Just simple logic. In c8
=(a7-a8)*24

--
Don Guillett
SalesAid Software

"wiskeyjruiz" wrote in message
...
I need help to set up a formula on Excel Worksheet.
Exsample: I need to Subtract cell A8 from A7; then Mutiply it by

"24."
But I need this formula on cell C8. Can I get some help with this

problem?






NazliTokbay

In cell C8 you type:
=(A7-A8)*24
This should resolve your problem.
"wiskeyjruiz" wrote in message
...
I need help to set up a formula on Excel Worksheet.
Exsample: I need to Subtract cell A8 from A7; then Mutiply it by "24."
But I need this formula on cell C8. Can I get some help with this problem?





All times are GMT +1. The time now is 05:40 AM.

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