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
Make Share function in Edge more useful
HotCakeX in Discussions on
2 Replies
function talking to table storage
donquijote in Compute on
0 Replies
Calculated column help
gopalaraoa in SharePoint on
1 Replies
Excel If Functions
Mfouad2255 in Excel on
10 Replies
Combining IF and INDEX functions
Hans van Deursen in Windows PowerShell on
2 Replies