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
Help with an IF AND formula
aanaya6 in Excel on
3 Replies
IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS
thomasea in Excel on
6 Replies
Which formula to use
Ramon Haagen in Excel on
2 Replies
Excel If Functions
Mfouad2255 in Excel on
10 Replies
function talking to table storage
donquijote in Compute on
0 Replies
Calculated column help
gopalaraoa in SharePoint on
1 Replies