Help With a Formula

[edrachel]

I am trying to develop a formula that will return two possible answers.
I want it to look in cell F6. If the number in F6 is less than 5, then I want it to return a 1. If the number in F6 is 5 or greater then I want it to return the number on sheet DED!A1:A11,2. How do I do this. I have tried the following:
=IF(F6<5,1,IF(F6>5,(DED!A1:A11,2,false)) Can anyone fix this for me?? What am I doing wrong? Thanks.

[VBA Noob]

Hi,

You seem to have the makes of a Vlookup.

Are you after something like this

=IF(F6<5,1,IF(F6>5,(VLOOKUP(F6,DED!$A$1:$B$11,2,FALSE))))

VBA Noob

[Paul]

So if F6 < 5, you want your cell to show "1". If F6 > 5, your cell should show the value of "DED!A1:A11,2"? I'm not sure what that means. Are you looking for the SUM of the values in A1:A11? Are you trying to do a VLOOKUP from that other sheet based on the value in F6, and getting that value returned?

If you simply wanted the value from DED!A1, the formula would be:

=IF(F6<5,1,DED!A1)

Another question - what do you want to show when F6=5. The IF statement (above or yours) does not account for that. It could easily be incorporated, though.

EDIT: Looks like Noob beat me. That'll teach me not to refresh my browser.