I am trying to set a simple formula as follows: H7: Result of Formula G6: Original Value ($20.69) G7: New Value ($10.28) H7 is...

how do I add the results of if formulas =if(I3="YES","5", IF(I3="NO", "0")). or how can I convert the results of this if formula to a number and later add it...

Hi 1. From Cell A1:E1 random numbers from 1 to 13 gets inputed and gets ranked then put in under A2:E2 i.e. any numbers from 1 to 13 can be inputed into...

Hello- My due date should be the 1st of the month if the start date is after the 15th or the 1st of the previous month if the start date is before the 15th,...

I'm trying to add cells WITH numbers but they have letters (alphanumerical). Example: A B C D E Total of sick days (S) ...

Is there a way to format an Excel date such that - the day of the week appears as a single letter? SMTWTFS or - the month appears as a single letter?...

How do I sort the data in the columns, I want to make them appear in alphabetical order? It is a list of DVDs with some of the actors. I've just tried to...

Hi I am trying to copy down a sheet reference with a step value of 51, any pointers as I cannot seem to get "edit - fill- series" to work. My cells...

I have columns that have quite a bit a bit of data in them and some of the numbers are the same.. I would like to be able to find the number that appears...

$1B3 thru B20 has names of people. $1C3 thru C20 has numbers. There are some duplicate names in B3 thru B20. When I enter name in $2D4 I would like $2E4...

Bill date qty Bill amt Pay.date Amt Bal. Days A B C D E F I J 18-Jul 18 800 19-Jul ...

Hi everyone, I am having alot of difficulties trying to solve this problem. Basically I am coding something in column A like this; 1. 11XXX (X being any...

How do I find out how many times Group 1,2,3 used each test? Using Excel 2000 A B C D E F Group Test Group Test 1 Test 2 Test 3 1 Test 1 1 2 Test...

I am using activeX to create both my combobox and buttons. I have 2 comboboxes. Combobox11 is dependent on combobox10. My program is as follows: Sub...

What is the custom format to display numbers to the nearest 100 or nearest 10, i.e., 721 be displyed as 700 or 720. I know that formattig a number that way...

Hi! Sir Can you help me in this regard. Attached Link is having the data in which I use vlookup with some repeated entries but I couldn’t find the...

I need to give at the end of a row, a total of a particular value, say 7.5, to various letter like W or L, S ,O, etc ---some 10 letters--or sum an...

I have an array comprised of two columns and and 8 rows. The left column contains an ascending list of numbers -- 91, 181, 366, etc. The right column...

Hello: I have the problem how to re-format the data. I have attached the sample sheet. The original data was in Sheet-A and already define the name as...

I need to graph the function y=2sin 0.5 PI x But a) it wont recognise x b) it wont graph a sine curve Why? and how do I fix it?