Looking for formula for the following: Column C cells can only be "IN" or "OUT". IF C1 is "IN" then E1=D1. IF C1 is "OUT" then E1= D1-10. IF D1 is empty then E1 remains empty.
Looking for formula for the following: Column C cells can only be "IN" or "OUT". IF C1 is "IN" then E1=D1. IF C1 is "OUT" then E1= D1-10. IF D1 is empty then E1 remains empty.
=if(D1="","",if(C1="in",D1,if(C1="out",D1-10)))
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Try
=IF(D1="",E1="",IF(C1="IN",D1,D1-10))
As always, the responses to my requests are quick and correct...many thanks again,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks