Formula help

M

MamaBee

Hi Folks,
Thanks for being here.
I'm just learning Excel 2007 and hope someone here can give me a formula
that will solve my problem..

A1 = $12445.54 (Input value)

B1 = $4978.22 (result of simple formula =sum(C1*D1))

Problem: Do not want B1 to calculate beyond the value in A1 regardless of
values in C1 or D1.

Can anyone steer me in the right direction ?

TIA
MamaBee
 
Z

Zaidy036

Hi Folks,
Thanks for being here.
I'm just learning Excel 2007 and hope someone here can give me a formula
that will solve my problem..

A1 = $12445.54 (Input value)

B1 = $4978.22 (result of simple formula =sum(C1*D1))

Problem: Do not want B1 to calculate beyond the value in A1 regardless of
values in C1 or D1.

Can anyone steer me in the right direction ?

TIA
MamaBee


for B1 use =min(A1,sum(c1:d1))

but note that you might want to use a conditional format to highlight where the
value comes from.
 
M

MamaBee

How simple ! This works great. I don't know that I will ever understand
'nested' formulas.
My sincere thanks.
MamaBee
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top