simple if won't work

[msohare91]

Hi. I am trying to do a simple if formula to divide another cell if the text value is true and to leave it as is or *1 if false. I have the below:

=IF(J2="USC",I2/100,*1).

So if J2 ="USC" I want it to divide i2 by 100 and just leave it as is if not USC. I can't see the issue with this and have also tried an IF AND formula but that didn't work.

I've done many of these IFs with one type of operation so I assume the / and * is causing the issue...

Thanks!

 

[RoryA]

You haven't specified what to multiply by 1, so either:

=IF(J2="USC",I2/100,I2*1)

or just:

=IF(J2="USC",I2/100,I2)

or even:

=I2/IF(J2="USC",100,1)

 

[Dave Patton]

try

T202104a.xlsm
	I	J	K
2	500	USC	5
2e

Cell Formulas
Range	Formula
K2	K2	=IF(J2="USC",I2/100,I2)

 

[msohare91]

You haven't specified what to multiply by 1, so either:

=IF(J2="USC",I2/100,I2*1)

or just:

=IF(J2="USC",I2/100,I2)

or even:

=I2/IF(J2="USC",100,1)

Great thanks for this. I guess I thought I'd already specified that the logical test was on J2 being X. So I'm not sure why you have to again specify what you want done to cell I2 if the logical test is false as assumed that was implied. Good to know for future ref.