Formula help

[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

 

[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.

 

[MamaBee]

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