Home |
Search |
Today's Posts |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Should I use a macro for this function? | Excel Discussion (Misc queries) | |||
Is there a Function or Macro for This? | Excel Discussion (Misc queries) | |||
Sub Macro vrs Function Macro Auto Start | Excel Discussion (Misc queries) | |||
macro or function? | Excel Discussion (Misc queries) | |||
Macro With IF Function | Excel Worksheet Functions |