Feb 12 2018 03:13 PM
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
Feb 12 2018 03:55 PM - edited Feb 12 2018 03:55 PM
SolutionHi 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
Feb 12 2018 03:55 PM - edited Feb 12 2018 03:55 PM
SolutionHi 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