Hi,
You structured you question as if it was
VB but posted in worksheet
functions so here's a worksheet one for you to try
=IF(AND(K28,K2<15),(K2-7)*0.05,IF(K2=15,((K2-14)*0.07)+0.3,0))
Mike
"MAE" wrote:
Basically, I am trying to create an if then else statement in Excel and I
have no idea how to do it. What I am trying to achieve is...
IF ( K2 between 8 and 14 ) THEN
((K2 -7) * .05)
ELSE IF
(K2 = 15 ) THEN
(((K2 - 14) *.07) + .30)
ELSE
( K2 * .0 )
Can anyone help me on this???
Thank you!
MAE