Thread: Greater than but less than formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default Greater than but less than formula
=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



Reply With QuoteReply With Quote