The worksheet looks like following:
A1=350; B1= ; C1=-350
a.The forumula in C1 was =A1-B1
b. B1 was blank
c. I had to enter the formula in B1?
What formula goes on B1?
The worksheet looks like following:
A1=350; B1= ; C1=-350
a.The forumula in C1 was =A1-B1
b. B1 was blank
c. I had to enter the formula in B1?
What formula goes on B1?
Last edited by aashrestha; 05-16-2009 at 05:40 AM.
please give me some suggestion!!!
What you mean by that?
Formula that calulate something else? Of formula that connect A1 and C1?
Wich you shouldn't do because you'll get circular reference, wich you better avoid.
well
=2*A1
would do it
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
I had
A1=350, B1 blank, C1=-350
When I clicked on C1, on formula bar I saw =C1-B1 ( hardly remember). And I had to enter a formula on B1?
=C1-B1 wouldnt be in c1
what is the point of this question?
if you can't remember what's what.
i know ,let's get a ouija board out and try with that
Last edited by martindwilson; 05-16-2009 at 05:33 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks