| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
making a spread sheet
if for eg: i have ID1 in one cell i would like another cell to say 34
for eg: if H1 was"IDE" then can i make J1 say"44" |
|
#2
|
|||
|
|||
|
=IF(H1="ID1",34,IF(H1="IDE",44,""))
-- HTH Bob Phillips "lofty" wrote in message ... if for eg: i have ID1 in one cell i would like another cell to say 34 for eg: if H1 was"IDE" then can i make J1 say"44" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel spread sheet | Excel Discussion (Misc queries) | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
| How do you add an Excel spread sheet to a Microsoft Word report? | Excel Worksheet Functions | |||
| in excel, how do i set up a spread sheet that automatically total. | New Users to Excel | |||
| How do I get the top 4 rows of a spread sheet to print on each pa. | Excel Discussion (Misc queries) | |||
Linear Mode
