How to add a default value (if less than function) to a calculation

**dbaseguy** · 09-23-2009, 10:57 AM

Might be the eastest thing in the world but I'm missing it

I can't seem to figure out how to do this in excel? FoxPro no problems, Excel and I have problems? Go figure.

Currently I'm dealing with this

=IF(C4="",0,IF(C4>=1,(B4+D4+E4+F4+H4)))

My problem is I want to add a minimum default value to this calculation.

If my return from this string is less than $25 I want to return the value of $25 otherwise if it is greater than $25 I want to return the calculation of this string?

Any help would be greatly appreciated. Thanks!

**shg** · 09-23-2009, 10:58 AM

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

**dbaseguy** · 09-23-2009, 10:58 AM

It might even be the Easiest thing in the world too!

**shg** · 09-23-2009, 11:26 AM

Thanks.

=IF(C4="", 0, IF(C4>=1, MAX(25, B4+D4+E4+F4+H4) ) )

**dbaseguy** · 09-23-2009, 11:38 AM

Hey,

Thanks for the help.

**shg** · 09-23-2009, 11:41 AM

Hey, you're welcome. Would you please mark the thread as Solved?

How to add a default value (if less than function) to a calculation

LinkBack

Thread Tools

Rate This Thread

Display

How to add a default value (if less than function) to a calculation

Re: Might be the eastest thing in the world but I'm missing it

Re: Might be the eastest thing in the world but I'm missing it

Re: How to add a default value (if less than function) to a calculation

Re: How to add a default value (if less than function) to a calculation

Re: How to add a default value (if less than function) to a calculation

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions