Help with IF calculation

  • Thread starter Thread starter Wazza
  • Start date Start date
W

Wazza

:)

I created a table from b64 to c82 with the numbers 3-21 scrolling down
and the values that correspond to these crom c64 down. Then I put tha
into the formula of =IF(J12<3,"",VLOOKUP(J12,$B$64:$C$82,2)) , J12 i
currently equalling 3 but the cell is still coming up with #N/A.

Thank
 
Hi

looks right, okay, let's see what the format is of the cell with 3 in it,
right mouse click on J12, choose format cells - is "text" selected. If so,
click on the OK button, then click on an unused cell somewhere (maybe even
on another sheet) & copy it, click on J12 again and choose edit / paste
special - ADD and click OK.

See if this solves the problem. If not, if you want to remove anything
sensitive from the workbook and email direct to me, i'll take a look
(julied_ng at hcts dot net dot au).

Cheers
JulieD
 

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

Help with IF calculation 1
If and value between two numbers 6
Please help with SUM formula dependent on results of other cells 2
Help with IF calculation 2
Count if on Single Criteria with multiply conditions 1
IF with multiple formula/variable 5
IF equation will not calculate 1
Help with IF calculation 1

Back
Top