Trying to figure out how to do an IF statement, a ROUNDUP and an AND statement in the same cell. Example
Cell A1 the number 75 in it
Cell A2 has an X in it
Cell A3 has my formula
I want the formula to say if cell A2 has an X in it, and cell A1 is <75, divide the number in A1 by 30 and round up. If cell A2 doesn't have an X, then leave the cell blank.
Cell A1 the number 75 in it
Cell A2 has an X in it
Cell A3 has my formula
I want the formula to say if cell A2 has an X in it, and cell A1 is <75, divide the number in A1 by 30 and round up. If cell A2 doesn't have an X, then leave the cell blank.