Thread: how can i set one cell is this the other is that (ex: D2=10 then D
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default how can i set one cell is this the other is that (ex: D2=10 then D
Enter formula in D5:
=IF(D2=10,6,"what if not 10?")

Regards,
Stefi

€žDar€ť ezt Ă*rta:

how can set in excel one cell equal to this then the other cell must equal that
like cell D2 value is 10 then cell D5 value is 6
Reply With QuoteReply With Quote