Hi MWH,

Ok, Just one more question :) is there a way to concatenate this
formula?=SUM(daily_Totals!F6) and your formula
=IF(F8=E8,"",IF(F8E8,"p","q")


It is not apparent what you mean by 'concatenate' in this context.

Certainly it is possible to replace one or more of the above cell references
with an expressions which return values. For example:

= If(SUM(daily_Totals!F6) Some_Value, "p","q")

You would, however, need to provide details sufficient for someone to
construct an appropriate formula.

More particularly, in your initial post you clearly enunciated the
A1A2 and A1<2 conditions..

If you can provide similar information for the SUM(daily_Totals!F6)
expression, I am sure that solutions will be forthcoming.

---
Regards,
Norman



"MWH" wrote in message
...
Hi Norman

Ok, Just one more question :) is there a way to concatenate this
formula?=SUM(daily_Totals!F6) and your formula
=IF(F8=E8,"",IF(F8E8,"p","q")
I'm getting the data from another worksheet, and I would like
the up-arrow or down-arrow to show next to the value. I am trying to
develop
an indicator to track man-hours and show where are our overall gains or
losses are coming from. The original data is coming from access and
exported
to excel. Thanks again!

"Norman Jones" wrote in message
...
Hi Ernestgoh,

I know this off topic but I read with interest on conditional
formatting. How do you go abouts setting the condtion? I went to
Edit-Go To-Special.


:Debra Dalgleish has a superb tutorial on conditional formatting (one of
a number!) at:

http://www.contextures.com/xlCondFormat01.html


---
Regards,
Norman



"ernestgoh"
wrote in message
...