Search : in
By :

EXCEL VALIDATION

Last answer on Oct 25, 2009 4:04:42 am GMT rao.cv2, on Oct 24, 2009 11:14:05 am BST 
 Report this message to moderators

Hello,
If I am having A1 is fixed value and E1= B1+C1+D1 & BUT E1 SHOULD NOT BE MORE THAN A1, IN HOW I CAN VALIDATE E1 WITH A1

Configuration: Windows XP Internet Explorer 6.0

Best answers for « EXCEL VALIDATION » in :
Import contacts from Excel to Outlook ShowImport contacts from Excel to Outlook Issue Solution Issue How to import a contact list from Excel to Outlook and having them in a single list of contact , and not as splited items? Solution By using the software Excel 2000 and...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
How to convert Excel into PDF? ShowHow to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. Step 1 PDF995 is software that gets installed on your computer which enables you to print any sources of document to...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Ask your question Reply

1

 venkat1926, on Oct 25, 2009 4:04:42 am GMT

Do you mean to say that if B1+c1+d1 is more than A1 E1should be A1

try(if necessary modify) this formula

=IF(SUM(B1:D1)<=A1,SUM(B1:D1),A1)

   
Reply to venkat1926
Ask your question Reply
They need your help