costing values

[hugoalegria]

I have a spread sheet that has the following information
column A Column B Column C
1.35 3.5
1.40 3.5
1.45 3.5
1.40 3.5

I need a formula such that if A3 is> than A4 (which is the average of
A1:A3), then I use that value in column C for final costing, If A3 is not >
then A4,then I would like to use A4 (the average ) for final costing.

Thanks in advance.

 

[akphidelt]

Try

If(A3>A4,A3,A4)

 

[FSt1]

hi
somehing like this
=if(A3>A4,C3,A4)

Adjust to your data.

Regards
FSt1

 

[Red]

how about this:

=if(A3>A4,C3,A4) Im assuming the costing value for A3 is in C3. What
this will not take into account is if A3 and A4 are equal. If you want to
default to A3 if A3 and A4 are equal just change it to this.
=if(A3>=A4,C3,A4)

 

[Sandy Mann]

=Max(A3,A4)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[hugoalegria]

thank you this works,
--
halegria

Try

If(A3>A4,A3,A4)

 

[hugoalegria]

Thank you for your observations, = was something i had not considered.

 

[hugoalegria]

Thank you, Thank you, This was unbelivebly cool, All the other formulas
worked very well, however this was simple and elegant. Thank you
--
halegria

=Max(A3,A4)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Sandy Mann]

You're very welcome. Thanks for the thanks.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

Thank you, Thank you, This was unbelivebly cool, All the other formulas
worked very well, however this was simple and elegant. Thank you