View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JonGall JonGall is offline
external usenet poster
 
Posts: 2
Default One Cell (J3) Answer Is Based On Text In Another Cell (I3)...

Here's what I need to do:
If cell I3 has the text "NO", then cell J3 will be equal to cell E3
(basically J3 will have the same number as E3).

But If cell I3 has the text "YES", then cell J3 will be E3*L3.

What function will complete the above?

Thanks,

JG