How do i write a formula that will look at A1, if it is more than .25 put
the value "5.00" in B1, if it is not more than .25, put the value "0.00"

I am sure this is easy, and on any other day i could probably figure it out.
Today, my brain isn't responding to simple commands! Thanks

One way assuming A1 will never contain a text entry:

=(A1=0.25)*5

Format as NUMBER 2 decimal places

--
Biff
Microsoft Excel MVP


"pakmount" wrote in message
...
How do i write a formula that will look at A1, if it is more than .25 put
the value "5.00" in B1, if it is not more than .25, put the value "0.00"

I am sure this is easy, and on any other day i could probably figure it
out.
Today, my brain isn't responding to simple commands! Thanks

In B1 use =IF(A10.25,5,0) and format for two decimal places.

"pakmount" wrote in message
...
How do i write a formula that will look at A1, if it is more than .25 put
the value "5.00" in B1, if it is not more than .25, put the value "0.00"

I am sure this is easy, and on any other day i could probably figure it
out.
Today, my brain isn't responding to simple commands! Thanks