LinkBack URL
About LinkBacks
Hi guys,
If you look at my sheet, D5 must stay blank, unless a value is entered in either B5 or E5, or both, in which case it must return the formula (D4+C5-F5)
thanx
Hi guys,
If you look at my sheet, D5 must stay blank, unless a value is entered in either B5 or E5, or both, in which case it must return the formula (D4+C5-F5)
thanx
Last edited by Schalk; 09-09-2014 at 04:25 AM. Reason: solved
Without looking at the spreadsheet
in D5
=IF(OR(B5<>"",E5<>""),D4+C5-F5,"")
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Copy it in D5
=IF(OR(C5="",E5=""),"",IFERROR(D4+C5-F5,""))
Punnam
try
Formula:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks