Using IF statements in conjunction with other function

  • Thread starter Thread starter meggie
  • Start date Start date
M

meggie

Hi,
I am having trouble figuring out the best way to enter into a cell a maximum
and minimum weight.

I want the statement to contain the follow logic:

=If(current weight+ live weight gain<300kg, then enter 300. However IF the
current weight + live weight gain >500kg, then enter 500)

I currently have the following formula and am getting that I am missing a
parenthensis,

=IF(CF16+CG11>Assumptions!$B$15,Assumptions!$B$15,'with flow'!CF16+'with
flow'!CG11, (IF(CF16+CG11<Assumptions!B91,Assumptions!B91,'with
flow'!CF16+'with flow'!CG11))

I can not seem to be able to be able to have the logic to put this formula
togther and I keep getting an error.
Any help would be fantastic.
Thanks in advance.
PS it is the weight of cows not people!
 
Try the belo
=IF(CF16+CG11>aSSUMPTIONS!$B$15,aSSUMPTIONS!$B$15,IF(CF16+CG11<aSSUMPTIONS!B91,aSSUMPTIONS!B91,'WITH FLOW'!CF16+'WITH FLOW'!CG11))

If this post helps click Yes
 
Back
Top