I'm trying to enter an IF formula but can't seem to get it written
correctly...what I want to do is " IF x is or = $150 then the value is 5,
if less than 150 then value is 0."

=IF(A1=150,5,0)

--
Gary''s Student - gsnu200838


"Peekaboo012885" wrote:

I'm trying to enter an IF formula but can't seem to get it written
correctly...what I want to do is " IF x is or = $150 then the value is 5,
if less than 150 then value is 0."

A2 contains "x"

=IF(OR(A2150,A2=150),5,0)

Peekaboo012885 wrote:

I'm trying to enter an IF formula but can't seem to get it written
correctly...what I want to do is " IF x is or = $150 then the value is 5,
if less than 150 then value is 0."

Not really necessary to use OR.
You can change =IF(OR(A2150,A2=150),5,0) to =IF(A2=150,5,0)
--
David Biddulph

"Bob I" wrote in message
...
A2 contains "x"

=IF(OR(A2150,A2=150),5,0)

Peekaboo012885 wrote:

I'm trying to enter an IF formula but can't seem to get it written
correctly...what I want to do is " IF x is or = $150 then the value is
5, if less than 150 then value is 0."

Thanks for the reminder.

David Biddulph wrote:

Not really necessary to use OR.
You can change =IF(OR(A2150,A2=150),5,0) to =IF(A2=150,5,0)
--
David Biddulph

"Bob I" wrote in message
...

A2 contains "x"

=IF(OR(A2150,A2=150),5,0)

Peekaboo012885 wrote:


I'm trying to enter an IF formula but can't seem to get it written
correctly...what I want to do is " IF x is or = $150 then the value is
5, if less than 150 then value is 0."

=IF(X=150,5,0)

It's better to use cell references. for example =IF(A1=150,5,0)

Thanks

"Peekaboo012885" wrote in message
...
I'm trying to enter an IF formula but can't seem to get it written
correctly...what I want to do is " IF x is or = $150 then the value is
5,
if less than 150 then value is 0."

thanks for the replies but I just realized I didn't word my question
correctly...I'm looking to assign that formula but to a range of cells in a
column (k3 through k50), however I want the total of all in cell k51.

"Gaurav" wrote:

=IF(X=150,5,0)

It's better to use cell references. for example =IF(A1=150,5,0)

Thanks

"Peekaboo012885" wrote in message
...
I'm trying to enter an IF formula but can't seem to get it written
correctly...what I want to do is " IF x is or = $150 then the value is
5,
if less than 150 then value is 0."

Perhaps you should rewrite the question in it's entirety as the
piecemeal approach is rather ambiguous.

Peekaboo012885 wrote:

thanks for the replies but I just realized I didn't word my question
correctly...I'm looking to assign that formula but to a range of cells in a
column (k3 through k50), however I want the total of all in cell k51.

"Gaurav" wrote:


=IF(X=150,5,0)

It's better to use cell references. for example =IF(A1=150,5,0)

Thanks

"Peekaboo012885" wrote in message
...

I'm trying to enter an IF formula but can't seem to get it written
correctly...what I want to do is " IF x is or = $150 then the value is
5,
if less than 150 then value is 0."

If in cell K51 you want the sum of K3 to K50, the formula in K51 is
=SUM(K3:K50)
If K3 to K50 is where you have your values that you want to test against
150, try =5*COUNTIF(K3:K50,"="&150)
--
David Biddulph

"Peekaboo012885" wrote in message
...
thanks for the replies but I just realized I didn't word my question
correctly...I'm looking to assign that formula but to a range of cells in
a
column (k3 through k50), however I want the total of all in cell k51.

"Gaurav" wrote:

=IF(X=150,5,0)

It's better to use cell references. for example =IF(A1=150,5,0)

Thanks

"Peekaboo012885" wrote in
message
...
I'm trying to enter an IF formula but can't seem to get it written
correctly...what I want to do is " IF x is or = $150 then the value
is
5,
if less than 150 then value is 0."

If you want to check the value in A1, you could put this formula in B1:

=if(a1=150,5,0)



Peekaboo012885 wrote:

I'm trying to enter an IF formula but can't seem to get it written
correctly...what I want to do is " IF x is or = $150 then the value is 5,
if less than 150 then value is 0."

--

Dave Peterson