How to write a greater if formula that shows a value?

[trav2016]

I have a set of values between R123:V123 I'm tring to write a formula that
will show the value in S123 only if it is above the value in R123 and if not
then leave blank.

[Bob Phillips]

Use conditional formatting with a formula of

=S123<=R123

and set the font colour to white.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"trav2016" <trav2016@discussions.microsoft.com> wrote in message
news:6403765C-0AF8-46F6-BE63-632C36FBFE00@microsoft.com...
> I have a set of values between R123:V123 I'm tring to write a formula that
> will show the value in S123 only if it is above the value in R123 and if
not
> then leave blank.

[trav2016]

Thank you but I was hoping of just getting the value and not a "true" or
"false" and to leave blank if the value is then the value in R123

"Bob Phillips" wrote:

> Use conditional formatting with a formula of
>
> =S123<=R123
>
> and set the font colour to white.
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "trav2016" <trav2016@discussions.microsoft.com> wrote in message
> news:6403765C-0AF8-46F6-BE63-632C36FBFE00@microsoft.com...
> > I have a set of values between R123:V123 I'm tring to write a formula that
> > will show the value in S123 only if it is above the value in R123 and if
> not
> > then leave blank.
>
>
>

[Peo Sjoblom]

You can't do that since you are referring to the same cell that holds the
formula, I don't you understood Bob's answer,. he suggested you use
format>conditional formatting and formula is, then select a white font
That way it won't be visible


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"trav2016" <trav2016@discussions.microsoft.com> wrote in message
news:EDC0B041-FEA2-48E4-8BF7-0CA17B315194@microsoft.com...
> Thank you but I was hoping of just getting the value and not a "true" or
> "false" and to leave blank if the value is then the value in R123
>
> "Bob Phillips" wrote:
>
>> Use conditional formatting with a formula of
>>
>> =S123<=R123
>>
>> and set the font colour to white.
>>
>> --
>> HTH
>>
>> Bob Phillips
>>
>> (remove nothere from email address if mailing direct)
>>
>> "trav2016" <trav2016@discussions.microsoft.com> wrote in message
>> news:6403765C-0AF8-46F6-BE63-632C36FBFE00@microsoft.com...
>> > I have a set of values between R123:V123 I'm tring to write a formula
>> > that
>> > will show the value in S123 only if it is above the value in R123 and
>> > if
>> not
>> > then leave blank.
>>
>>
>>

[BruceP]

How are you getting the numbers into those cells? If you're pulling them in through a formula or function, you can include an IF() function to stop it from loading into the cell:

=IF(x1>r23,x1,"")

If you just don't want to see the number, you can use Conditional Formatting. You can set the font color to the background color if the Cell Value condition is met.

HTH

Bruce

[trav2016]

Sorry for being unclear, I'm tring to have a value from R123:V123 show in
another diagram between B176:F176 but, I want only values from S123:V123 that
are greater then the value in R123 to show in C176:F176. B176 would have the
value equal to R123. If the value between S123:V123 is less then R123 I would
like to leave it blank in the diagram of C176:F176.

"BruceP" wrote:

>
> How are you getting the numbers into those cells? If you're pulling
> them in through a formula or function, you can include an IF() function
> to stop it from loading into the cell:
>
> =IF(x1>r23,x1,"")
>
> If you just don't want to see the number, you can use Conditional
> Formatting. You can set the font color to the background color if the
> Cell Value condition is met.
>
> HTH
>
> Bruce
>
>
> --
> BruceP
> ------------------------------------------------------------------------
> BruceP's Profile: http://www.excelforum.com/member.php...o&userid=33653
> View this thread: http://www.excelforum.com/showthread...hreadid=536902
>
>

[trav2016]

ok Im an idiot, here's the formula I need =IF(B176<=S123,S123," ") I wrote it
wrong the first time( no space between the " marks) Thanks for your help.

"trav2016" wrote:

> I have a set of values between R123:V123 I'm tring to write a formula that
> will show the value in S123 only if it is above the value in R123 and if not
> then leave blank.