Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
vlookup and if function
hiya all
i'm trying to make 2 dropdown lists which when added with a figure in a 3rd cell copies the cell into another column. i.e a1=(dropdown"january") b1=(dropdown"paid") c1=("manual input"100) in g1 i want the total 100(c1) only if a1& b1 is set above. but what i also want is if a1=jan,b1=paid,c1=200 and g1 is full(1) then enter 200(c1) into g2 please help. -- deejay |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
vlookup and if function
On the face of it, this might suffice
In G1: =IF(AND(A1="january",B1="Paid"),C1,"") In G2: =IF(G1=200,G1,"") -- Max Singapore http://savefile.com/projects/236895 Downloads:17,500 Files:358 Subscribers:55 xdemechanik --- "confused deejay" wrote: i'm trying to make 2 dropdown lists which when added with a figure in a 3rd cell copies the cell into another column. i.e a1=(dropdown"january") b1=(dropdown"paid") c1=("manual input"100) in g1 i want the total 100(c1) only if a1& b1 is set above. but what i also want is if a1=jan,b1=paid,c1=200 and g1 is full(1) then enter 200(c1) into g2 please help. -- deejay |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
vlookup and if function
hiya max thanx for the reply tried your sum but didn't work.
might be my fault, then again what i'm asking might be impossible! your sum worked on the first base but when i entered a new figure in c1 it changed g1 aswell i need it so once the sum has been added it stays and the next time its added its added one row down (g2)(g3)(g4) so on... without changing the figure in (g1)(g2)(g3) -- deejay "Max" wrote: On the face of it, this might suffice In G1: =IF(AND(A1="january",B1="Paid"),C1,"") In G2: =IF(G1=200,G1,"") -- Max Singapore http://savefile.com/projects/236895 Downloads:17,500 Files:358 Subscribers:55 xdemechanik --- "confused deejay" wrote: i'm trying to make 2 dropdown lists which when added with a figure in a 3rd cell copies the cell into another column. i.e a1=(dropdown"january") b1=(dropdown"paid") c1=("manual input"100) in g1 i want the total 100(c1) only if a1& b1 is set above. but what i also want is if a1=jan,b1=paid,c1=200 and g1 is full(1) then enter 200(c1) into g2 please help. -- deejay |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
vlookup and if function
Not sure whether the lack of responses from others here over the past few
days confirms your statement: .. then again what i'm asking might be impossible! You might want to try posting in .programming -- Max Singapore http://savefile.com/projects/236895 Downloads:17,500, Files:358, Subscribers:55 xdemechanik --- "confused deejay" wrote in message ... hiya max thanx for the reply tried your sum but didn't work. might be my fault, then again what i'm asking might be impossible! your sum worked on the first base but when i entered a new figure in c1 it changed g1 aswell i need it so once the sum has been added it stays and the next time its added its added one row down (g2)(g3)(g4) so on... without changing the figure in (g1)(g2)(g3) -- deejay |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
vlookup and if function
probably lol i've got some IT blokes looking at it for me. i guess what i'm
trying to do should be possible if you take this site for instance i'm writing this text on a window box! that window box then adds what i write to the main page display. that display is never taken off its just added too!! the next time i open this window this message will be deleted, although remaining on the main page. all i wanna do is incorporate this tech into an excel sheet. -- deejay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Embedded If Function in a Vlookup Function | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION | Excel Worksheet Functions | |||
how do I write a vlookup function within an iserror function so t. | Excel Worksheet Functions | |||
I want to use Vlookup function and AND function in a single formu. | Excel Worksheet Functions |