View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

=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"