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