LinkBack Thread Tools Search this Thread Display Modes
  #11   Report Post  
Old November 22nd 05, 07:50 PM posted to microsoft.public.excel.worksheet.functions
Posts: n/a
Default Nested IF problem - help please

I'll give it a shot!



  #12   Report Post  
Old November 22nd 05, 09:23 PM posted to microsoft.public.excel.worksheet.functions
Posts: n/a
Default Nested IF problem - help please


Formatting should not cause the #N/A error. There must be something
other than "oct" either in B2 or in the K8. The fact that it works
with the data validation only proves that if you put whatever is in K8
in B2 the formula will find it, but if the contents of K8 are "Oct "
("Oct" with space following), putting "oct" in B2 without a following
space will not work.

As for the small drop-down font, you have just what I thought you had -
a small zoom and large cell font, which will make your drop-down font
very small. I assume you have corrected it by now by reducing the font
size in all your cells, changing the row heights and column widths to
match the new font size and increasing the zoom factor.

I see little reason for zoom factors of less than 100% unless you want
to see your overall sheet layout, after which you would revert to 100%.
It also helps to show more on smaller screens of course, but you then
negate the effect by using such large font.


Declan O'R

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with nested IF_OR statement DOOGIE Excel Worksheet Functions 7 June 24th 05 03:27 AM
Copy an Drag cell Formula Problem Nat Excel Discussion (Misc queries) 1 June 20th 05 03:24 PM
problem office assistant R.VENKATARAMAN Excel Discussion (Misc queries) 0 June 15th 05 06:22 AM
Problem with nested subtotals, placing secondary subtotals BELOW . Dawn Cameron Excel Discussion (Misc queries) 1 June 3rd 05 10:13 PM
“Use of more then 7 nested if statement” Faisal Yameen Excel Worksheet Functions 2 January 12th 05 04:20 PM

All times are GMT +1. The time now is 07:13 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017