Thread: IF formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default IF formula

=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."