Re: Up Arrows / Down Arrows

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Ok, Just one more question :) is there a way to concatenate this
formula?=SUM(daily_Totals!F6) and your formula
=IF(F8=E8,"",IF(F8>E8,"p","q")
I'm getting the data from another work***, 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" <normanjones@xxxxxxxxxxxxxxxxxxx> wrote in message
news:uvTy43wfFHA.2372@xxxxxxxxxxxxxxxxxxxxxxx
> Hi MWH,
>
> Try Changing:
>
> =If(A2>A1, "p","q")
>
> To
>
> =IF(A1=A2,"",IF(A2>A1, "p","q")
>
> --
>
> ---
> Regards,
> Norman
>
>
>
> "MWH" <mhanfor1@xxxxxxxxxxx> wrote in message
> news:LWwxe.93589$g5.42227@xxxxxxxxxxxxxxxxxxxxxxx
>> One more question if A2 = A1, i don't want an arrow to show, right now I
>> always get a down arrow
>>
>>
>> "Norman Jones" <normanjones@xxxxxxxxxxxxxxxxxxx> wrote in message
>> news:ul3b3NrfFHA.1148@xxxxxxxxxxxxxxxxxxxxxxx
>>> Hi MWH,
>>>
>>> Try the following two-pronged approach:
>>>
>>> (1) In B2: =If(A2>A1, "p","q") Format with Windings3 font.
>>>
>>> (2) Set conditional formats for the three possible cases:
>>>
>>>
>>> =A1>A2 | Font: Bold Red
>>> =A1<A2 | Font: Bold Green
>>> =A1 =A2 | Font: Normal White
>>>
>>>
>>> ---
>>> Regards,
>>> Norman
>>>
>>>
>>>
>>> "MWH" <mhanfor1@xxxxxxxxxxx> wrote in message
>>> news:2Bmxe.93548$g5.82994@xxxxxxxxxxxxxxxxxxxxxxx
>>>> If cell A2 > A1 I would like to show an up arrow next to the value, and
>>>> visa versa...
>>>>
>>>> --
>>>> Mark W. Hanford
>>>> mhanfor1@xxxxxxxxxxxx
>>>>
>>>
>>>
>>
>>
>
>


.

Quantcast