Thread: Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Formula

Hi,

If statements take the form of

=if(a1=somthing,do this if true,do this if false)

If you tell us what the true and false conditions evaluate as then someone
will help

Less then equal to is done using =

Mike

"knight" wrote:

I want create formula, =IF A1<100*.8, IF A1<200*.6, IF A1 <300*.5.
And where is the less than/ equal sign at?