Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi
On a user form I have 2 Text Boxes in which to enter cash figures Excluding TAX - on the worksheet these 2 figures enter columns E & G - in column K I have the formula =IF(SUM(E3+G3)=0"", SUM(E3+G3)*17.5% - If I create a new Text Box on the user form could it generate the Tax as the formula above and then on clicking Add Iformation Button it would enter column K thus doing away with the formula in column K on the worksheet which is sometimes altered by mistake. Any help much appreciated Cheers ---- Mully |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I create a formula in Excel that evaluates form information? | Excel Worksheet Functions | |||
Formula for Excel User Name | Excel Worksheet Functions | |||
User Form to Mail Merge | New Users to Excel | |||
User Form Picture | New Users to Excel | |||
A "previous" button on a user form | Excel Discussion (Misc queries) |