Home |
Search |
Today's Posts |
#10
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Nevermind, I got it figured out. I had started selecting from row 2, so when
I plugged in the formulas as row 1, it threw everything up one row. DOH!!! *smacks forehead* Thanks a bunch guys, works great, HUGE help!!! :) "bodhisatvaofboogie" wrote: That is a good catch, I changed that, but the highlighting and bolding is still off. "David Biddulph" wrote: "Bob Phillips" wrote in message ... First, you need to select the whole row. Then you should use absolute column references (my bad sorry). So in all I think it is =OR(AND($K1=13,$K1<=98),$K1100) and =AND($K1=99,$V22=0)) Did you mean $V22, or $V1? -- David Biddulph |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
IF Statement problem | New Users to Excel | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
What statement to use? | Excel Worksheet Functions |