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
Highlighted
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?
Related Conversations