Hello all,
I'm new to excel and have been teaching myself slowly to help with some tasks I'm faced with at work.
I'm working on a table right now.
Column A has different types of carriers (A1=broadcast, A2=government, A3=Data, etc)
Column B is where i'd like to put the $ amount of rent that each different type of carrier pays
I tried =If(A1="broadcast", 350) ...and that works, but how do I create a formula where if A1= broadcast B1 will equal $350 or if A1=government then B1=250
I tried =IF(OR(F2="broadcast",350),OR(F2="government",250)) but it keeps returning TRUE.
I also tried doing =IF(or(and....but that didn't work either.
can anyone fix my formula and also explain why it works that way and not how I'm doing it?
thank you so much!!
Bookmarks