Home |
Search |
Today's Posts |
#1
|
|||
|
|||
user input function
I need help making it where I can input a quantity if another cell has text
in it. I am using the IF function and currently have it set up like this: IF(A1="","", ????). I need to know what to put in place of the question marks so that I can input information into that cell when A1 has something written in it. Thank you |
#2
|
|||
|
|||
If I understand correctly, your formula is OK.
If you want to use a number IF(A1="","", 1234) If you want text IF(A1="","", "Your Text") To use the value in another cell, say H1 IF(A1="","", H1) Regards, Alan. "BLW" wrote in message ... I need help making it where I can input a quantity if another cell has text in it. I am using the IF function and currently have it set up like this: IF(A1="","", ????). I need to know what to put in place of the question marks so that I can input information into that cell when A1 has something written in it. Thank you |
#3
|
|||
|
|||
It's not a text that I already know, it will be inputted by a user, so it
can't be set for a certain text. Thank you "Alan" wrote: If I understand correctly, your formula is OK. If you want to use a number IF(A1="","", 1234) If you want text IF(A1="","", "Your Text") To use the value in another cell, say H1 IF(A1="","", H1) Regards, Alan. "BLW" wrote in message ... I need help making it where I can input a quantity if another cell has text in it. I am using the IF function and currently have it set up like this: IF(A1="","", ????). I need to know what to put in place of the question marks so that I can input information into that cell when A1 has something written in it. Thank you |
#4
|
|||
|
|||
Oh I see. Although you don't know what the user will input, do you know the
whole range of potential values that the user might input? That's to say are there a set number of values, say ten possible answers to a question? If so you could put them in a two column table with the possible answers in column D and the values you want to display in column E and use something like IF(A1="","", VLOOKUP(A1,D1:E10,2,FALSE) If that's as clear as mud please post back! Regards, Alan "BLW" wrote in message ... It's not a text that I already know, it will be inputted by a user, so it can't be set for a certain text. Thank you "Alan" wrote: If I understand correctly, your formula is OK. If you want to use a number IF(A1="","", 1234) If you want text IF(A1="","", "Your Text") To use the value in another cell, say H1 IF(A1="","", H1) Regards, Alan. "BLW" wrote in message ... I need help making it where I can input a quantity if another cell has text in it. I am using the IF function and currently have it set up like this: IF(A1="","", ????). I need to know what to put in place of the question marks so that I can input information into that cell when A1 has something written in it. Thank you |
#5
|
|||
|
|||
Where and how will it be inputted by user?
If inputted in H1, use Alan's =IF(A1="","", H1) Gord Dibben Excel MVP On Fri, 20 May 2005 13:44:03 -0700, BLW wrote: It's not a text that I already know, it will be inputted by a user, so it can't be set for a certain text. Thank you "Alan" wrote: If I understand correctly, your formula is OK. If you want to use a number IF(A1="","", 1234) If you want text IF(A1="","", "Your Text") To use the value in another cell, say H1 IF(A1="","", H1) Regards, Alan. "BLW" wrote in message ... I need help making it where I can input a quantity if another cell has text in it. I am using the IF function and currently have it set up like this: IF(A1="","", ????). I need to know what to put in place of the question marks so that I can input information into that cell when A1 has something written in it. Thank you |
#6
|
|||
|
|||
Alan,
it's jsut a number...the user will select a product and I need them to be able to input a quantity into a box but only if there is text in an adjacent box. Thank you. "Alan" wrote: Oh I see. Although you don't know what the user will input, do you know the whole range of potential values that the user might input? That's to say are there a set number of values, say ten possible answers to a question? If so you could put them in a two column table with the possible answers in column D and the values you want to display in column E and use something like IF(A1="","", VLOOKUP(A1,D1:E10,2,FALSE) If that's as clear as mud please post back! Regards, Alan "BLW" wrote in message ... It's not a text that I already know, it will be inputted by a user, so it can't be set for a certain text. Thank you "Alan" wrote: If I understand correctly, your formula is OK. If you want to use a number IF(A1="","", 1234) If you want text IF(A1="","", "Your Text") To use the value in another cell, say H1 IF(A1="","", H1) Regards, Alan. "BLW" wrote in message ... I need help making it where I can input a quantity if another cell has text in it. I am using the IF function and currently have it set up like this: IF(A1="","", ????). I need to know what to put in place of the question marks so that I can input information into that cell when A1 has something written in it. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
user defined function row number | Excel Worksheet Functions | |||
INDEX, user input? | Excel Worksheet Functions | |||
how to move user defined function | Excel Worksheet Functions |