| Home |
| Search |
| Today's Posts |
|
|
|
#1
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? |
| Reply |
| 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 | |||
Hybrid Mode
