I am having trouble getting syntax right using IF and AND in Excel 2010
what I want to do is perform an operation in a cell wherein:
IF A99 = "Basic" AND D105="Distance Between Corners" then D104 otherwise 1.154*D104
Thanks in Advance!
I am having trouble getting syntax right using IF and AND in Excel 2010
what I want to do is perform an operation in a cell wherein:
IF A99 = "Basic" AND D105="Distance Between Corners" then D104 otherwise 1.154*D104
Thanks in Advance!
Try this one.
=IF(AND(A99="Basic",D105="Distance Between Corners"),D104,1.154*D104)
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks