Re: If/Then formula

Claus Busch

Guest

Posts: n/a

2nd May 2012

Hi Howard,

Am Wed, 02 May 2012 19:15:17 GMT schrieb howard stovall:

> How do I format the following in Excel:
> Cell formula is =E33*.2; If e33*.2 < $20,000 then cell value = $20,000

try:
=MAX(E33*0.2,20000)

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

« Disable Microsoft Office File Validation | Re: If/Then formula »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Replace formula with IF(error(formula;"";formula)	=?Utf-8?B?bGVjYWJhbGxlcm8=?=	Microsoft Excel Programming	1	2nd Nov 2005 12:46 PM
insert formula using VB - displays formula as string, not result	Dom Boyce	Microsoft Excel Discussion	1	27th Feb 2004 11:08 AM
How to place a cell formula after the formula result in the cell?	Dmitriy Kopnichev	Microsoft Excel Discussion	10	28th Nov 2003 01:22 PM
Need Help Nesting a Formula inside MAX formula	Terra S.	Microsoft Excel Discussion	8	21st Oct 2003 10:58 PM
Commenting custom formula fields/formula on formula editor	Muxer	Microsoft Excel Programming	2	24th Jul 2003 01:02 AM