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
Highlighted
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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
205 Replies