| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
if greater then 99 then 1 if greater then 199 then two
im trying to find out if a value in a cell is greater then 99 then it should
say 1 if its greater then 199 then it should say 2 and so on and so on up to 999 what im really trying to do is find out if i had a total of $325.35 what increments i need such as hundreds fiftys twentys tens fives and so on if any one know that would be great if im dreaming well i guess im dreaming thanks N.R. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I filter a list using a greater than todays date function? | Excel Worksheet Functions | |||
| Help with SUMIF, INDEX, LOOKUP Please !! | Excel Worksheet Functions | |||
| Help w/ SUMIF ; INDEX | Excel Worksheet Functions | |||
| If Greater than when a formula Results in N/A | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Threaded Mode
