Excel formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2998463%22%20slang%3D%22en-US%22%3EExcel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2998463%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20community%2C%20I%20have%20a%20table%20with%20several%20columns.%20I%20would%20like%20to%20use%20a%20function%20that%20in%20one%20cell%20does%20not%20let%20me%20put%20a%20smaller%20number%20than%20it%20is%20in%20another%20previous%20cell%2C%20in%20the%20same%20row.%20Can%20anyone%20help%20me%20with%20this%20formula%3F%20I%20tried%20this%3A%20'%3D%20IF%20(B%20%3CA%3E%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2998463%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2998485%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2998485%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1227767%22%20target%3D%22_blank%22%3E%40Gabriel985%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(B3%3CA3%3E%3C%2FA3%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20what%20you%20are%20looking%20for%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2998491%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2998491%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1174419%22%20target%3D%22_blank%22%3E%40Quadruple_Pawn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20realy.%20I%20want%20it%20to%20give%20me%20an%20error%20in%20that%20box%20when%20I%20enter%20a%20value%2C%20meaning%20not%20to%20let%20me%20enter%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello community, I have a table with several columns. I would like to use a function that in one cell does not let me put a smaller number than it is in another previous cell, in the same row. Can anyone help me with this formula? I tried this: '= IF (B <A, "ERROR", B), yes it doesn't work.

3 Replies

@Gabriel985 

=IF(B3<A3," ERROR",B3)

 

Is this what you are looking for?

@Quadruple_Pawn 

 

Not realy. I want it to give me an error in that box when I enter a value, meaning not to let me enter it.

@Gabriel985 

=B3>A3

 

This data validation rule allows entries B3>A3 and rejects entries B3<A3.