needing a formula to calculate.

[Yfrain Cruz]

trying to calculate "chr"column based on "wgt" column

problem: if "wgt" ≤ 3 then value=5  but if value ≥4 then value to be multiplied by 1.45

[#2 · Accepted solution]

Hi Yfran

Thanks for the screen shot.

Try this formula:

=IF(A3<=3,5,A3*1.45)

I've also attached a mock up of the sheet you have shown, along with the working formula for you to play with.

See how you go and let us know if this is the solution to what you want?

Cheers

Damien

[#3]

Thank you.  It did the trick

[#4]

No worries. All the best!

Cheers
Damien