Thread: IF statement with a range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ricky ricky is offline
external usenet poster
  
Posts: 10
Default IF statement with a range
Hi

Is there anyway I can write the following:

IF(D20 and <5000000, "5m","0m")

To populate another cell for reporting purposes.

Kind Regards

Ricky


Reply With QuoteReply With Quote