I am a not very advanced at all with excel. I am working on a project that I am needing this formula to not work if one of the cells is blank.
=(P10-D6)*P9
This is what I have, which works great if all cell values are entered. If a cell is blank it calculates and gives me a number I don't need to have displayed.
Any and all help would be greatly appreciated.
Give this try
Formula:
Please Login or Register to view this content.
Last edited by shukla.ankur281190; 03-06-2018 at 01:37 AM. Reason: Missed one criteria
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
welcome to the forum. which of the 3 cells needs to be blank to return a blank? if it is just P10:
=IF(P10="","",(P10-D6)*P9)
if it could be any of the 3:
=IF(OR(P10="",D6="",P9=""),"",(P10-D6)*P9)
=IF(COUNT(P10,D6,P9)<3,"",(P10-D6)*P9)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks