# If statement - unable to work out why it doesn't work

1. ## If statement - unable to work out why it doesn't work

This is probably an easy problem but I can't get my head around why it's not working. I am normally good with this but somehow my logic is not working.

What has gone wrong?

2. ## Re: If statement - unable to work out why it doesn't work

In what way do you think it's wrong?

3. ## Re: If statement - unable to work out why it doesn't work

sorry. when I changed the threshold to 4,000,000,001 it defaults to 2.5bps but it's suppose to be 3 and if I changed to 2,000,000,000 it defaults to 3 and not 3.5

so i think it's to do with my formula

4. ## Re: If statement - unable to work out why it doesn't work

The way you have it set up you need to change the threshold in the table AND the formula.
Do it this way below and you only need to change the value in the table.

Split column L into two columns, put the lower values in column L (e.g. 0 and 1000000001 etc) and the higher values (1000000000 and 2000000000 etc) in column M.
Your table is now in L8:N11

Now change the formula in column F to

=VLOOKUP(E14,L\$8:N\$11,3,1)

Values from your original formula look ok to me (I only had a quick glance).

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1