Thread: If formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TomPl TomPl is offline
external usenet poster
  
Posts: 342
Default If formula
=IF(ISBLANK(A1),ROW(),"")

"Horacio" wrote:

I´m tray to make a formula in column B1 that when I introduce data in
column A1 give me 1 and when I introduce data in A2 give me 2 in
column B2

A1 B1
15 1
25 2
30 3
30 4

Thank you

Horacio
.

Reply With QuoteReply With Quote