|
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 |
=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 |
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 |
| All times are GMT +1. The time now is 02:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com