Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
error message
My worksheet is set up as follows:
Cell A1 to A220 have budgeted amount. Cell C1 to AK220 are for allocation of the budgetd amount Cell B1 to B220 are to the total of C1 to AK220 Is there a way to do validation to ensure that allocation amount entered in C to AK does not exceed the corresponding row in Cell A. So for example, if A1 has total budgeted amount 1000, the amount entered in C1 to AK1 should not exceed 1000. If does, it should give an error message. I try various validation rules. It is not working. Any help will be greatly appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
error message
You could try something like:
=IF(SUM(C1:K1)1000,"Exceeds Budget",1000) in cell A1 - this would either have the budget amount 1000 or Exceeds Budget. edvwvw Paul_of_Abingdon wrote: My worksheet is set up as follows: Cell A1 to A220 have budgeted amount. Cell C1 to AK220 are for allocation of the budgetd amount Cell B1 to B220 are to the total of C1 to AK220 Is there a way to do validation to ensure that allocation amount entered in C to AK does not exceed the corresponding row in Cell A. So for example, if A1 has total budgeted amount 1000, the amount entered in C1 to AK1 should not exceed 1000. If does, it should give an error message. I try various validation rules. It is not working. Any help will be greatly appreciated. -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error Message | Excel Discussion (Misc queries) | |||
Error message........ | Excel Discussion (Misc queries) | |||
VBA Error Message "Compile Error...." | Excel Discussion (Misc queries) | |||
changing the message in an error message | Excel Worksheet Functions | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) |