No Idea What Function Or Formula Would Be Called?

[Brad1m]

Hi Guys:

Im trying to build a fairly basic calculator but I need to use 1 cell twice with 2

functions. Does that make any sense???

My problem lies in cell C8

Here are my formula's =SUM(D3/(A8*10)) This one is in C8
And this one uses C8 =SUM(C8*A8)*10 but is in D8

=SUM(D3/(A8*10)) gives me the amount of options contracts I can buy with the amount in D3

=SUM(C8*A8)*10 Should give me the total cost of that amount of contracts wich should be higher or lower than D3, but it just gives me the value of D3

Am I making any sense at all???

I dont know what function or formula I need to make =SUM(C8*A8)*10 only see the value in the cell instead of seemingly reading the formula?

I want it to read a number like 13 or 21 or something but it wont.

Can anyone help I've been at this all day and it's only a 1hr job "if that?" for someone who knows what they are doing.
​

 

[JackDanIce]

Can you provide an example of your worksheet - below doesn't make much sense.

As an FYI:

=SUM(C8*A8)*10)

Gives me the same value as:

=C8*A8*10

So I'm not sure why you're wrapping that inside a SUM function

Similarly for your first formula, you don't need the SUM part

 

[RoryA]

If C8 = D3/(A8*10)
then C8*A8*10 equals:
D3/(A8*10)*(A8*10) = D3

I don't really know what else you are expecting.

 

[jasonb75]

In C8, one of

=ROUND(D3/(A8*10),0)
=ROUNDDOWN(D3/(A8*10),0)
=ROUNDUP(D3/(A8*10),0)

Changing the cells format doesn't automatically round the formula results.

 

[Brad1m]

Thanks Jason, JackDanIce, Rorya


Jason: By removing the =Sum and the () this made the formula work.

JackDanIce: The ROUNDDOWN function fixed another problem I was having.

Rorya: your comment made me think a bit harder about what I was actually doing...

Thanks Guys, you got me straightened out.

I'm no genius that's for sure!