Thread: If then formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mjmeyer mjmeyer is offline
external usenet poster
 
Posts: 4
Default If then formula

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