Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need quick "if" function
How do I get a value to repeat itself if it's under or over a certain value.
for example. Is a value is greater than 5 in one cell, then I want to repeat it in another column of cells I want to do the same for when a value is less than say, 5.1 ... and have it repeat in a different column of cells. What's the easiest way to do that? Thanks so much. Diana |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to sum up data using "if" function?? | Excel Discussion (Misc queries) | |||
3 step "if" function | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
use "if" and "max" in the same function | Excel Worksheet Functions | |||
How do I use The "if" function | Excel Worksheet Functions |