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. |
#2
|
|||
|
|||
If your # is in cell A1, here's the answer
=IF(MOD(A1,100)=99,1+INT(A1/100),INT(A1/100)) I'm assuming your numbers are 199 as opposed to 1.99 which may not be a valid assumption. There are a lot of answers to the 2nd part, but I'd have to think about it in EXCEL. "N.R." wrote: 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. |
#3
|
|||
|
|||
A worksheet formula?
=INT(A2/100) -- HTH Bob Phillips "N.R." wrote in message ... 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. |
Reply |
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 |