Thread: What is the if formula?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default What is the if formula?
Suppose I want to test if the value in A1 is greater than 10
=IF(A10,"It is greater than 10", "Not greater than 10")

The syntax (rule) is
=IF( test, what_you_want_if_test_is_TRUE, what_you_want_if_test_is_FALSE)

Experiment a little and you will soon catch on
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"Sherees" wrote in message
...

--
Life isa journey not a destination

Reply With QuoteReply With Quote