View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default first time he IF function problem

SE may be sum
if(f2<=100,(c2-f1)*j2,"ok")

--
Don Guillett
SalesAid Software

"Dave F" wrote in message
...
=IF(SE(F2<=100),(C2-F2)*J2,"OK")

What is SE?

Dave
--
Brevity is the soul of wit.


"Kit" wrote:

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