A Blank in a formula

  • Thread starter Thread starter \·.¸¸.·´¯`Skywalker´¯`·.¸¸.·\
  • Start date Start date
·

\·.¸¸.·´¯`Skywalker´¯`·.¸¸.·\

Hi i hope someone can help i have been to many sites and goole search etc:
looking for a formula for a blank in a cell if no input in another cell,

Eg c8 has no number and d8 has no figure(£) amount and e8 shows £0.00
but i want e8 to show nothing if there is nothing imputed into c8
however i have a formula in e8 =D8*C8

and have tried =if(c8<1,d8"")(=d8*c8)
also =d8*c*=if(c8<1,d8"",)
also =if(c8"",D8"",d8*c8)

and a few others that i cant remember at this time if anyone can help
thankyou even a web page with alot of examples
 
Thankyou this is the formula that worked
=IF(OR(C8="",C8=" "),"",D8*C8)

Thanks again
 

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

Formula Assistance 6
IF information is in cell A8 then Formula is active? 1
Summing a range of cells based on criteria in another range 2
Logic statements 1
Using formulas from Quattro Pro in Excel 2007 4
How do I get the IF function to work on more than one criterion? 5
disregard a cell on occasion when there is text in it instead of V 5
Array Fromula 6

Back
Top