View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 1,726
Default first time he IF function problem

It must be the square brackets

=SE(F2<=100;(c2-f2)*j2;"OK")

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Kit" wrote in message
oups.com...
Dear friends,
I am just trying to use IF function for having to use a calculation if
true: =SE(F2<=100;[(c2-f2)*j2];"OK").

I am not able to combine IF with calculation: anyone can help me?


Many thanks

Giuseppe