Using IF statements in conjunction with other function

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!
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF AND calculations with date 5
Formula nesting with IF statements 2
Arrayformulas with either/or nested to sumproduct if eitherconditions are true 13
IF function 3
Testing for conditions with IF statement and AND function 1
Subtraction Function using cells with other functions in them 2
MX-16 well worth a try. 25
Using "If" combined with "AND" statements 1

Top