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!
=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!