If then formula

[pakmount]

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

 

[T. Valko]

One way assuming A1 will never contain a text entry:

=(A1>=0.25)*5

Format as NUMBER 2 decimal places

 

[Mav_2006]

One way assuming A1 will never contain a text entry:

=(A1>=0.25)*5

Format as NUMBER 2 decimal places

--
Biff
Microsoft Excel MVP

I can see this works and is very neat, but not sure I understand how - would you (please) be able to explain.

 

[mjmeyer]

In B1 use =IF(A1>0.25,5,0) and format for two decimal places.