sunshinereel2
New Member
- Joined
- Jul 21, 2016
- Messages
- 9
Need some assistance. Need to have this formula return a " " if there is not a quanity(number) in the cell being referenced. However, the cell being referenced has a formula in it to return needed results so I get a value error. Is there a better way to complete this?
=IF(ISBLANK(M87)," ",M87*N87) is in cell P87
In cell M87 is a formula that is =D87
D87 result is dependent on what is selected in Cell A74.
Any help would be greatly appreciated and please let me know if you have a question to clarify what I am asking.
Thank you and I appreciate your time.
=IF(ISBLANK(M87)," ",M87*N87) is in cell P87
In cell M87 is a formula that is =D87
D87 result is dependent on what is selected in Cell A74.
Any help would be greatly appreciated and please let me know if you have a question to clarify what I am asking.
Thank you and I appreciate your time.