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.
Bookmarks