Home

IF Function

%3CLINGO-SUB%20id%3D%22lingo-sub-685151%22%20slang%3D%22en-US%22%3EIF%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-685151%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETrying%20to%20do%20an%20IF%20Function%20so%20-%20If%20value%20%3D%20True%20then%20x%20column%20by%201.02%25%20however%20if%20higher%20then%201.02%25%20then%20use%20this%20amount.%20If%20false%20then%20follow%20on%20with%20other%20IF%20function.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-685151%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-685277%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-685277%22%20slang%3D%22en-US%22%3EI%20am%20afraid%20your%20question%20is%20not%20clear%20enough.%3CBR%20%2F%3ECan%20you%20please%20post%20some%20sample%20data%20with%20examples%20for%20the%20several%20situations%20that%20you%20refer%20and%20explain%20better%20what%20you%20need%3F%3C%2FLINGO-BODY%3E
Bradenj
Occasional Visitor

Hi,

 

Trying to do an IF Function so - If value = True then x column by 1.02% however if higher then 1.02% then use this amount. If false then follow on with other IF function.

 

Thanks

1 Reply
I am afraid your question is not clear enough.
Can you please post some sample data with examples for the several situations that you refer and explain better what you need?