View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default Greater than but less than formula

No need IF function

AND(A15,A1<8)


"Toppers" wrote:

=if(and(A15,A1<8),true,false)

"Storm" wrote:

Hello.

Is there a formula that will allow me to do a certain function if:
the value of a cell is (for example) greater than 5 but less than 8?

I appreciate any help.

Thanks,
Storm