Thread: i need help with a function application with multiple arguments
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default i need help with a function application with multiple arguments
One way:

=IF(a<4500,b,IF(a<7500,c,d))

In article ,
tarabull wrote:

if a is less than 4500 then b, if a is greater than or equal to 4500 but less
than 7500 then c, if a is greater or equal to 7500 then c
Reply With QuoteReply With Quote