| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula? | Excel Worksheet Functions | |||
| writing a formula for a colored value | New Users to Excel | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| Simplify formula | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
