In the file attached I simply want to make a formula that does as follows. If column A1 has the subdivision name "other" I would like it to use this formula for g2 (VDL MOS)=D2/E2*12, otherwise I would like to be able to free hand in whatever value I would like.
In other words if A1 says other it will use the formula, if A1 says anything else it will let me free hand in whatever value I would like for G2(VDL MOS)
Hi,
if by "free hand" you mean entering a value manually, then I don't think it will work.
A cell is either used for data entry or it has a formula that calculates a value. You cannot have both. You can start out with a formula, but as soon as you overtype that with a value, the formula will be destroyed.
You could do something like this:
=IF(A2="other",D2/E2*12,K2)
and use cell K2 to enter your manual value, which will then be displayed in G2
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks