if a13=0 then 0 if not then (a13*10%+10+a13)

J

JulieD

Hi

is this what you're after

=IF(A13="","",A13*1.1+10)
which will give you nothing if A13 is nothing and 110% of A13 plus 10 if A13
has a value
if you want 0 if A13 has nothing in it then try
=IF(A13="",0,A13*1.1+10)

Cheers
JulieD
 

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

Spread values across fields 1
vlookup function returning "na" even though the vlaues are present 2
Conditional sum, when condition has multiple values 3
If , Mid or right functions or a combination thereoff. 3
IF statement with multiple VLOOKUPs 0
VLOOKUP with a blank cell 5
If/Vlookup override 4
Combining Multilple Worksheets Into One 6

Top