Need to do an IFERROR formula in a 3rd colunm.

Question

If the first column A has a value &gt; 0 then I want an error if column c an d is fill with any number then show an error. Colum B has a formuls of A*.10, if we try to put a value on C it can make error because A is &gt;0.&nbsp; &nbsp; &nbsp; &nbsp; A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;E&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; F1&nbsp; &nbsp; &nbsp; &nbsp; 100&nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (I want an error message and cannot enter value in C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; 534&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; because A &amp; B is already fill&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

nikolinode · Answer

Guindina&nbsp;You can use data validation to prevent users from entering values in columns C and D if column A has a value greater than 0.&nbsp;Here’s how you can do this:Select the cells in columns C and D where you want to apply the data validation.Click on the&nbsp;Data&nbsp;tab in the ribbon and select&nbsp;Data Validation&nbsp;from the&nbsp;Data Tools&nbsp;group.In the&nbsp;Data Validation&nbsp;dialog box that opens, select&nbsp;Custom&nbsp;from the&nbsp;Allow&nbsp;drop-down menu.In the&nbsp;Formula&nbsp;field, enter the following formula:&nbsp;=IF($A1&gt;0,FALSE,TRUE)Click on&nbsp;OK&nbsp;to apply the data validation.&nbsp;Now, if a user tries to enter a value in columns C or D when column A has a value greater than 0, they will see an error message and will not be able to enter the value.You can also customize the error message that is displayed by clicking on the&nbsp;Error Alert&nbsp;tab in the&nbsp;Data Validation&nbsp;dialog box and entering your desired message.

Forum Discussion

Need to do an IFERROR formula in a 3rd colunm.

Share

Resources