 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / March 2008IF information is in cell A8 then Formula is active?
Wondering how to use an If function. I have information in A8 and D8 has a formula. It does not matter if the information is in A8, B8, or C8 just as long as the information is there and if so, then D8's formula will work, otherwise the formula returns nothing. This formula is in D8. =B8*CostperHour22.00-C8+D7 Thank you. Try this in D8: =IF(AND(B8<>"",C8<>"",D7<>""),B8*CostperHour22.00-C8+D7,"") Will return a blank cell if any of B8, C8 or D7 are blank. I presume CostperHour22.00 is a named range you have defined. Hope this helps. Pete On Mar 5, 8:58 pm, LiveUser <LiveU...@discussions.microsoft.com> wrote: > Wondering how to use an If function. > [quoted text clipped - 8 lines] > > Thank you. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.