| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using formulas/macros in conjunction with drop down lists | Excel Discussion (Misc queries) | |||
| How can I use an IFISNUMBER formula in conjunction with Vlookup? | Excel Worksheet Functions | |||
| cell color in conjunction with upcoming date | Excel Discussion (Misc queries) | |||
| how to move lines in conjunction with graphs | Charts and Charting in Excel | |||
| Using IF & AND command in conjunction | Excel Discussion (Misc queries) | |||
Threaded Mode
