Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF value
I need to create an equation.
If (roundup(AE104*2,-3)=300000) then =300000 or if (roundup(AE104*2,-3)<300000) then =roundup(AE104*2,-3) Basically: If y=x then x, if y<x then y |
#2
|
|||
|
|||
Christine --
Howz about: =if(y=x,x,y) hth, Peter "Christine Lombardo" wrote: I need to create an equation. If (roundup(AE104*2,-3)=300000) then =300000 or if (roundup(AE104*2,-3)<300000) then =roundup(AE104*2,-3) Basically: If y=x then x, if y<x then y |
#3
|
|||
|
|||
When I do that it always shows y as true when I know that it is not.
"pdberger" wrote: Christine -- Howz about: =if(y=x,x,y) hth, Peter "Christine Lombardo" wrote: I need to create an equation. If (roundup(AE104*2,-3)=300000) then =300000 or if (roundup(AE104*2,-3)<300000) then =roundup(AE104*2,-3) Basically: If y=x then x, if y<x then y |
#4
|
|||
|
|||
How about
=MIN(300000,ROUNDUP(AE104*2,-3)) -- HTH RP (remove nothere from the email address if mailing direct) "pdberger" wrote in message ... Christine -- Howz about: =if(y=x,x,y) hth, Peter "Christine Lombardo" wrote: I need to create an equation. If (roundup(AE104*2,-3)=300000) then =300000 or if (roundup(AE104*2,-3)<300000) then =roundup(AE104*2,-3) Basically: If y=x then x, if y<x then y |
#5
|
|||
|
|||
Christine -- I may not understand what you're trying to accomplish. I
created the following, which seems to work the way I understand you need: A B C 1 5 4 =IF(A1=B1,B1,A1) 2 5 5 copied down... 3 5 6 I got the following results: In 'C1' the result was 4, 'C2' was 5, and 'C3' was 5. Is that not a simplified version of what you wanted? hth "Christine Lombardo" wrote: When I do that it always shows y as true when I know that it is not. "pdberger" wrote: Christine -- Howz about: =if(y=x,x,y) hth, Peter "Christine Lombardo" wrote: I need to create an equation. If (roundup(AE104*2,-3)=300000) then =300000 or if (roundup(AE104*2,-3)<300000) then =roundup(AE104*2,-3) Basically: If y=x then x, if y<x then y |
#6
|
|||
|
|||
Thank you. That worked.
"Bob Phillips" wrote: How about =MIN(300000,ROUNDUP(AE104*2,-3)) -- HTH RP (remove nothere from the email address if mailing direct) "pdberger" wrote in message ... Christine -- Howz about: =if(y=x,x,y) hth, Peter "Christine Lombardo" wrote: I need to create an equation. If (roundup(AE104*2,-3)=300000) then =300000 or if (roundup(AE104*2,-3)<300000) then =roundup(AE104*2,-3) Basically: If y=x then x, if y<x then y |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|