|
Using IF statements in conjunction with other function
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+CG11Assumptions!$B$15,Assumptions!$B$15, 'with flow'!CF16+'with flow'!CG11, (IF(CF16+CG11<Assumptions!B91,Assumptions!B91,'wit h 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! |
Using IF statements in conjunction with other function
Try the below
=IF(CF16+CG11aSSUMPTIONS!$B$15,aSSUMPTIONS!$B$15, IF(CF16+CG11<aSSUMPTIONS!B91,aSSUMPTIONS!B91,'WITH FLOW'!CF16+'WITH FLOW'!CG11)) If this post helps click Yes --------------- Jacob Skaria "meggie" wrote: 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+CG11Assumptions!$B$15,Assumptions!$B$15, 'with flow'!CF16+'with flow'!CG11, (IF(CF16+CG11<Assumptions!B91,Assumptions!B91,'wit h 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! |
| All times are GMT +1. The time now is 04:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com