only use formula if > than 0

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I want to create a formula that only works if I have a figure in a cell

eg.,

A1 1.70
B1 =sum(a1*3.4%)+0.20

But if A1 was blank, I don't want any figure in B1.

Thanks for any help
 
=IF(ISBLANK(A1,"",A1*3.4%+.2)
no need for SUM function here.
Bob Umlas
Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF with criteria "<>" & "=" 4
SUMIF "value if false" not working 2
Excel formula, sum the value cell and if empty cell left blank 0
find out specific month and year 1
formula to add year to date figures 3
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
Excel functions 0
How to get string to use IF formula only when another cell is text 2

Back
Top