ExcelBanter - only use formula if than 0

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - only use formula if than 0 (https://www.excelbanter.com/excel-worksheet-functions/50896-only-use-formula-if-than-0-a.html)

owlie

only use formula if than 0

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

Bob Umlas

only use formula if than 0

=IF(ISBLANK(A1,"",A1*3.4%+.2)
no need for SUM function here.
Bob Umlas
Excel MVP

"owlie" wrote in message
...
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

Peo Sjoblom

only use formula if than 0

No need for sum here

=IF(A1="","",A1*3.4%+0.2)

--

Regards,

Peo Sjoblom

"owlie" wrote in message
...
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

JE McGimpsey

only use formula if than 0

One way:

=IF(COUNT(A1),A1*3.4%+0.20,"")

In article ,
"owlie" wrote:

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

All times are GMT +1. The time now is 01:09 AM.