=IF(AND(OR(D8=0,D8=""),E14<>""),D19,0)
The change I need to make is to exclude the range 9000-9998 from ""
=IF(AND(OR(D8=0,D8=""),E14<>""),D19,0)
The change I need to make is to exclude the range 9000-9998 from ""
you'll have to give us a bit more of a clue
exclude the range 9000-9998 from what? D8, E14, D19, or the cell the formula is in ?
Agree with ThirtyTwo. Also, is 9000-9998 an actual range, or is it text?
Perhaps upload a sample workbook for us to look at?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I have uploaded the attachment and you can look at the tab labeled Invoice Linzy Allen
E19 is dependant on an entry to D8 however currently if I enter any membership number then this brings the value in E19 to 0. I want the formula in E19 still to be true except where the member number in E8 is between 9000 and 9998 in which case the value in E19 would be 25.00 as it would if it was blank
Perhaps this?
=IF(AND(OR(AND(D8>=9000,D8<9999),D8=""),E14<>""),D19,0)
That is exactly what I needed Thanks so much
Mike
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks