Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional format formula
I need a formula that looks says any cell that does not contain a "-",
"0" or blank will now equal the number in column B. Any takers? Dave |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional format formula
If "0" or "-" or <blank in D12, then
=IF(OR(D12="-",D12="",D12="0"),B12,"not specified") There's probably a shorter way of doing this, but it works ok :) -- Traa Dy Liooar Jock "dzelnio" wrote: I need a formula that looks says any cell that does not contain a "-", "0" or blank will now equal the number in column B. Any takers? Dave |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional format formula
Here's one way:
=IF(AND(NOT(ISNUMBER(FIND("-",A1,1))),NOT(ISNUMBER(FIND("0",A1,1))),NOT(ISNUMB ER(FIND(" ",A1,1)))),B1,"") |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional format formula
I need a formula that looks says any cell that does *not* contain a "-",
"0" or blank will now equal the number in column B I think that Jock may have intended: =IF(OR(D12="-",D12="",D12="0"),"not specified",B12) or =IF(AND(D12<"-",D12<"",D12<"0"),B12,"not specified") note that by puting the zero in quotes it will only match with a text zero. This assumes that the OP intended that the cell contains *only* one of those characters and not contains one of the characters within other text. -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Jock" wrote in message ... If "0" or "-" or <blank in D12, then =IF(OR(D12="-",D12="",D12="0"),B12,"not specified") There's probably a shorter way of doing this, but it works ok :) -- Traa Dy Liooar Jock "dzelnio" wrote: I need a formula that looks says any cell that does not contain a "-", "0" or blank will now equal the number in column B. Any takers? Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula for Conditional Format | Excel Discussion (Misc queries) | |||
Conditional format formula | Excel Discussion (Misc queries) | |||
Conditional Format & Formula | Excel Worksheet Functions | |||
Conditional format formula | Excel Discussion (Misc queries) | |||
Conditional format with a formula | Excel Worksheet Functions |