View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default function arguments

Well, it's nice to see the formula -- better late than never. Now we need
more specifics.

1. What do you mean by "cant get it to work"?
2. What do you want to round?
3. Why is 500 in quotes in your formula?
4. When you tried to round, what formula did you use?

Regards,
Fred.

"Oregongal35" wrote in message
...
Sorry this is my formula,

I cant get it to work when i try to round the last part.

=IF(roc1*2%<500," 500",roc1*2%)


Thanks..

"Shane Devenshire" wrote:

Hi,

Probably

=ROUND(IF(A1=15,A1*25%,0),2)

You didn't show us the formula you were using so I made one up

Cheers,
Shane Devenshire

"Oregongal35" wrote:

I created a true and false function,
and if true then it equals 33*25%, how do i get the that number to
round in
my formula?