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
|