LinkBack URL
About LinkBacks
Sorry to keep posting simple questions, but I've never used excel before. What is the formula for d25 divided by c26?
Sorry to keep posting simple questions, but I've never used excel before. What is the formula for d25 divided by c26?
Last edited by oceanside; 01-21-2013 at 09:18 PM.
d25 formula is =IF(SUM(D5:D24)=0,"",SUM(D5:D24))
c26 formula is =IF(SUM(C5:C24)=0,"",SUM(C5:C24))
I don't know if that makes a difference though.
Try this:
=D25 / C26
Hope this helps.
Pete
In that case you want to avoid errors if C26 is blank - use this instead:
=IF(C26="","",D25/C26)
Hope this helps.
Pete
Thank you Pete!Originally Posted by Pete_UK
prior to your first post they have given you the formula
=IF(C25<>"",C25*0.4536,"") you can edit this to include an "and" something like below.
=IF(and(C26<>"",D25<>""),D25/C26,"")
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
oceanside,
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks