Nested IF Function not working
Take a look at how Mike constructed his AND function call, then look at how
you did it... Mike's construction is correct syntax, yours is not. And don't
forget to look at Dave's response in case you really wanted the number $260
and not the text "$260".
Rick
"Paula" wrote in message
...
I put in this, the number in K5 is 10, so according to this formula should
return $260, but will not return anything. What ever I put in the last
quotation marks, that is what it returns. Any suggestions? The actual
formula will have 11 parts, where this example only has 4 parts.
=IF(K5<3,"$50",IF(AND(K52<6),"$100",IF(AND(K55<9 ),"$180",IF(AND(K58<13),"$260",""))))
"Mike H" wrote:
Paula
=IF(L42<3,"$50",IF(AND(L422,L42<5),"$100",""))
Mike
"Paula" wrote:
This is the formula I put in:
=if(L42<3,"$50",if(L422<5,"$100")). Instead of returning $50 or $100
it
returns FALSE. What am I doing wrong?
Thank You.
|