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?
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?
Just simple logic. In c8
=(a7-a8)*24
--
Don Guillett
SalesAid Software
[email protected]
"wiskeyjruiz" <[email protected]> wrote in message
news:[email protected]...
> 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?
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" <[email protected]> wrote in message
news:[email protected]...
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?
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
> [email protected]
> "wiskeyjruiz" <[email protected]> wrote in message
> news:[email protected]...
> > 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?
>
>
>
if(myformula=0,"",myformula)
or
tools>options>view>zeros
--
Don Guillett
SalesAid Software
[email protected]
"wiskeyjruiz" <[email protected]> wrote in message
news:[email protected]...
> 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
> > [email protected]
> > "wiskeyjruiz" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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?
> >
> >
> >
In cell C8 you type:
=(A7-A8)*24
This should resolve your problem.
"wiskeyjruiz" <[email protected]> wrote in message
news:[email protected]...
> 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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks