Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Formula help!?

0 views
Skip to first unread message

buda

unread,
Jul 26, 2002, 2:23:58 PM7/26/02
to
Hi,

Could someone please help me figure out how to complete this
formula? So far all I have is this formula I want to enter
into cell B34 of my Excel 2000 spreadsheet:

=IF(SUM(B91:B116) > (B30-B26),,)

If the above formula statement is TRUE I need to put the
dollar amount being calculated from (SUM(B91:B116) into
cell B34 before it becomes greater than the amount
calculated from cells (B30-B26).

For example if the dollar amount calculated from cells
(B30-B26) equals $600.00 and the dollar amount being
calculated from (SUM(B91:B116) is $600.01 the dollar amount
in B34 would reflect $600.00.

If the above formula statement is FALSE I would like cell
B34 to just continue reflecting the amount being calculated
from (SUM(B91:B116).

TIA,

buda

Don Guillett

unread,
Jul 26, 2002, 2:35:52 PM7/26/02
to
I don't know why you can't finish that. Play with it.

--
Don Guillett
SalesAid Software
Granite Shoals, TX
don...@281.com
"buda" <bu...@umn.edu> wrote in message news:3D4193BE...@umn.edu...

Jason Morin

unread,
Jul 26, 2002, 2:36:12 PM7/26/02
to
=IF(SUM(B91:B116)>B30-B26,B30-B26,SUM(B91:B116))

HTH
Jason
Atlanta, GA

>.
>

buda

unread,
Jul 26, 2002, 3:02:54 PM7/26/02
to
Because I have tried and I'm very new at this:( Some real help would be
appreciated:)

Thx!

Don Guillett

unread,
Jul 26, 2002, 3:18:02 PM7/26/02
to
=if(cond1>cond2,cond2,cond1)
or
if(cond2>cond1,cond1,cond2)
This is not real hard.

--
Don Guillett
SalesAid Software
Granite Shoals, TX
don...@281.com

"buda" <bu...@umn.edu> wrote in message news:3D419CDE...@umn.edu...

Daniel Wheeler

unread,
Jul 26, 2002, 3:28:55 PM7/26/02
to
It's not real hard to you or to me, but for someone just starting out on
programming or Excel, it might be. I betcha there's quite a few things
that he doesn't think are hard that you would struggle at if you started
them too!

You may be much better at Excel than him, but showing patience and
leading him in the right direction would not only help him solve his
issue, but would make you look like a smarter guy by displaying your
teaching skills.

Debra Dalgleish

unread,
Jul 26, 2002, 3:29:37 PM7/26/02
to
What you want in cell B34 is the smaller of the two values, so you can
use the MIN function:

=MIN(B30-B26,SUM(B91:B116))


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

buda

unread,
Jul 26, 2002, 3:32:42 PM7/26/02
to
Hmm, that's really funny:( Do you get some sort of kick out of giving
non-constructive flip responses? I'm trying to get some help to a problem I'm
unable to figure out! I'm sure your the smartest person in the world and
perhaps that has gone to your head but if you are unable to give a constructive
answer to my question please feed your ego on another thread.

Good day!!

Don Guillett

unread,
Jul 26, 2002, 3:33:34 PM7/26/02
to
I did. I did. I did. He really had it if he had just played with it a bit.
That's how I learned. You?

--
Don Guillett
SalesAid Software
Granite Shoals, TX
don...@281.com

"Daniel Wheeler" <daniel....@big-baseball.com> wrote in message
news:3D419E5A...@big-baseball.com...

Don Guillett

unread,
Jul 26, 2002, 3:45:51 PM7/26/02
to
put the following in cell b34.
=IF(SUM(B91:B116)>SUM(B26:B30),SUM(B26:B30),SUM(B91:B116))

> > =if(cond1>cond2,cond2,cond1)
Have a nice weekend.

--
Don Guillett
SalesAid Software
Granite Shoals, TX
don...@281.com

"buda" <bu...@umn.edu> wrote in message news:3D41A3DA...@umn.edu...

buda

unread,
Jul 26, 2002, 3:50:19 PM7/26/02
to
Hmm, that's really funny:( Do you get some sort of kick out of giving
non-constructive flip responses? I'm trying to get some help to a problem I've
tried to solve on my own with my level of knowledge in Excel and I'm unable to
figure out. I'm sure your the smartest person in the world and perhaps you've
forgotten there is a person on the other end of this e-mail asking for some help
so if you are unable to communicate a constructive answer to my question please

feed your ego on another thread.

Good day!!

buda

unread,
Jul 26, 2002, 3:52:58 PM7/26/02
to
Thank you!!

buda

unread,
Jul 26, 2002, 3:55:11 PM7/26/02
to

Daniel Wheeler

unread,
Jul 26, 2002, 3:47:45 PM7/26/02
to
I built a database using PERL, Excel and Access and constantly work with
baseball stats in Excel spreadsheets. :-)

adam r

unread,
Jul 26, 2002, 11:00:26 PM7/26/02
to
=if(sum(b91:b116)>(b30-b26),(sum(b91:b116),(b30-b26)

it sounds dumb but as i type formulas i say them as a sentance...
works great for me.....

"if the sum of b91 through b116 is greater than b30 less b26,reflect
the sum of b91 through b116 OTHERWISE reflect b30 less b26.

if formulas are always formatted as (ARGUMENT,TRUE REFLECTION, FALSE
REFLECTION)

good luck

adam

buda <bu...@umn.edu> wrote in message news:<3D4193BE...@umn.edu>...

Nimish

unread,
Aug 5, 2002, 1:25:33 AM8/5/02
to
It seems you want to restrict cell value to minimum of SUM(B91:B116)
and (B30-B26). If so try with following formula -

=MIN(SUM(B91:B116),B30-B26))

For selecting maximum of above two use MAX function instead.

Trust this helps
Nimish

0 new messages