-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
validation using formula
-
F
Data validation from multiple sheets
IN SHEET 1- DAILY SALES RECORD IN SHEET 2- ALL TSHIRT SKU'S IN SHEET 3- ALL JEANS SKU'S SHEET 1- <tbody> DATE SKU COLOR QTY PRICE PROFIT </tbody> SHEET 2 AND 3- <tbody> SKU COLOR PRICE SELLING PRICE COMMISSION SHIPPING VAT @ 5% PROFIT </tbody> Now...- feroz_bilal
- Thread
- sales order validation using formula
- Replies: 5
- Forum: Excel Questions
-
B
Nesting Statements with Data Validation
Hello- Can anyone help me with a nesting statement that I am trying to work into the Data Validation Source and I can't seem to get around the error. I have 5 IF statements in Sheet1 that I am trying work into the Data Validation Source. So my formula should be: =IF($AM$16="South...- beans1181
- Thread
- nesting if statement validation using formula
- Replies: 2
- Forum: Excel Questions
-
F
custom validation formula with 2 condition
I want to validate cell C7, with two coditions, user can only enter Data either in time format (5:00, 19:56) or "Absent"- faizee
- Thread
- validation using formula
- Replies: 6
- Forum: Excel Questions
-
M
how to return an error if Cell C2 is greater than the sum of Cells A2 and B2
I have a table with 5 columns. The First Column is an Opening Balance, second column is Received Quantity, third column is Issued Quantity, fourth column is Closing Balance and the fifth column is Date. I am using this table to maintain a simple inventory. The very first cell under the Opening...- MAHENDRA WAMAN
- Thread
- data validation validation using formula
- Replies: 7
- Forum: Excel Questions
