Posted to microsoft.public.excel.programming

IIDavidJII IIDavidJII is offline

external usenet poster

Posts: 2

Function condition statement

Trying to create an aid for my micro economics work for Price Elasticities.
I need to create a conditional statement in absolute value for the following;

For the cell b14 (Price Elasticity Demand)

B14=0,"Perfectly inelastic Demand"
B14=1,"Unit-elastic"
B141,"Elastic"
B14<1 and 0, "Inelastic"

*all numbers need to be displayed in Absolute Value

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sumif function with a date range condition statement	COskibum	Excel Discussion (Misc queries)	4	July 24th 08 07:15 PM
IF statement...And condition	Rich D	Excel Discussion (Misc queries)	1	January 4th 08 03:50 PM
Condition Statement	Django	Excel Discussion (Misc queries)	5	August 26th 05 06:59 PM
Condition Statement Help??	CWit	Excel Programming	7	March 3rd 04 07:16 PM
Condition Statement	Stel	Excel Programming	4	December 9th 03 12:52 PM

All times are GMT +1. The time now is 08:12 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us