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

Problem using IF statement with dates as part of the formula 4
INDEX function array causes problem when attempting to use LARGEfunction to sort positive and negati 10
Testing for conditions with IF statement and AND function 1
Nested IF statements using AND / OR 2
Trouble constructing IF statement 1
Combining sumIF statements with other functions? 2
named ranges 4
Displaying Multiple Values without using Macros or ROWS function 4

Top