Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    17

    Unanswered: help with a formula

    hi
    im not very good with formulas so i wonder if anyone could help me out with this...if cell A19 is empty then show nothing, but if A19 does have something in it then work out D19*E19 in F19

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    im not very good with formulas so i wonder if anyone could help me out with this...if cell A19 is empty then show nothing, but if A19 does have something in it then work out D19*E19 in F19

    Put this in F19

    =IF(A19="","",D19*E19)

    HTH
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Jan 2004
    Posts
    17
    thanx thats great, worked a treat!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •