Thread: IF Macro / Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default IF Macro / Function
=((B15)+(B1=10))/2


"Kimmon" wrote:

PLEASE help, I need to create a Macro urgent and don't know how:

QUESTION:

If cell x <5 or 10 x = 0.5
If cell x 10 x = 1

My attempt:

=IF(B1<5,"0.5",IF(B110,"0.5",IF(B110,"1")))

It doesn't look right?
Reply With QuoteReply With Quote