| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula help please
Im trying to write a formula that basically says if the figure in J5 is less than or equal to what is in cell D8 AND less than or equal to what is in E8 then take the data from cell C8 ive tried to do an IF statement within another IF statement but i am getting an error. this is the formula i have tried =IF(J5=D8,(=IF(J5<=E8,C8,0)),0) Im sure im missing something simple but cant see it, can anyone help please? -- biggs ------------------------------------------------------------------------ biggs's Profile: http://www.excelforum.com/member.php...o&userid=27397 View this thread: http://www.excelforum.com/showthread...hreadid=469448 |
|
#2
|
|||
|
|||
|
=IF(AND(J5<=D8,J5<=E8),C8,0)
-- HTH Bob Phillips "biggs" wrote in message ... Im trying to write a formula that basically says if the figure in J5 is less than or equal to what is in cell D8 AND less than or equal to what is in E8 then take the data from cell C8 ive tried to do an IF statement within another IF statement but i am getting an error. this is the formula i have tried =IF(J5=D8,(=IF(J5<=E8,C8,0)),0) Im sure im missing something simple but cant see it, can anyone help please? -- biggs ------------------------------------------------------------------------ biggs's Profile: http://www.excelforum.com/member.php...o&userid=27397 View this thread: http://www.excelforum.com/showthread...hreadid=469448 |
|
#3
|
|||
|
|||
|
Try
=If(AND(J5<=D8,J5<=E8),C8,0) "biggs" wrote in message ... Im trying to write a formula that basically says if the figure in J5 is less than or equal to what is in cell D8 AND less than or equal to what is in E8 then take the data from cell C8 ive tried to do an IF statement within another IF statement but i am getting an error. this is the formula i have tried =IF(J5=D8,(=IF(J5<=E8,C8,0)),0) Im sure im missing something simple but cant see it, can anyone help please? -- biggs ------------------------------------------------------------------------ biggs's Profile: http://www.excelforum.com/member.php...o&userid=27397 View this thread: http://www.excelforum.com/showthread...hreadid=469448 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula? | Excel Worksheet Functions | |||
| writing a formula for a colored value | New Users to Excel | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| Simplify formula | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
