View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CIW CIW is offline
external usenet poster
 
Posts: 4
Default If Function with 3 arguments

I am trying to enter an IF function that has 3 separate arguments:

If C8 is <= to 199,999, then place the value 5,000;
If C8 is between 200,000 and 499,999, then place the value 10,000;
If C8 is = 500,000, then place the value 15,000.

I have not done functions for several years, and cannot remember how to
compose this function--can you please help me?

Carol