| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
first time he IF function problem
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
first time he IF function problem
=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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
first time he IF function problem
Based on the domain name of the OP it looks like SE is Italian for IF:
http://www.wordreference.com/iten/se In which case the OP's formula looks like it would be correct. -- Brevity is the soul of wit. "Don Guillett" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Mid Function Problem | Excel Discussion (Misc queries) | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| time problem or excel mistake | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
Linear Mode
