If cell a1 is ABC I then want to multiply cell a2 by a3, but if cell a1 is CBA I then want to * cell cell a2 by a4
Oldmillbill
If cell a1 is ABC I then want to multiply cell a2 by a3, but if cell a1 is CBA I then want to * cell cell a2 by a4
Oldmillbill
try
=A2*IF(A1="ABC", A3, A4)
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Close, but still having a problem. In my spreadsheet, column C is either CORN or SBEAN and if it is CORN I want to multiply column (Q*cell K1, but if it is SBEAN I need to multiply column (Q * J1.
What formula did you try and how did it fail?
I did get it to work. The problem I was having is that there were some blank spaces following the alpha-letters I was comparing to.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks