Formula help please

  • Thread starter Thread starter biggs
  • Start date Start date
B

biggs

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?
 
Try

=If(AND(J5<=D8,J5<=E8),C8,0)



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?
 

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

A Blank in a formula 4
Formula Assistance 6
OR & IF functions 6
Using formulas from Quattro Pro in Excel 2007 4
Logic statements 1
@IF Formula 3
Array Fromula 6
LOOKUP/IF Formula Help!! 1

Back
Top