Thread: if this equals that
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RJ
 
Posts: n/a
Default if this equals that
=if(A2="X",10,0)

"MAML" wrote:

I am trying to come up with a spreadsheet where if you either type in a X in
A2 ... in column C you will get 10. Then say if you leave A3 blank.. in
column C it will be 0.
Reply With QuoteReply With Quote