Thread: Nested IF Function not working
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paula Paula is offline
external usenet poster
  
Posts: 138
Default Nested IF Function not working
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.
Reply With QuoteReply With Quote