labellaluke
New Member
- Joined
- Dec 10, 2013
- Messages
- 3
I need to create a formula to do the following:
If B3 is greater than zero, calculate A3+72 (A3 is a date field)
If B3 is less than zero, leave cell blank.
I could also use if B3 is not blank, calculate A3+72
If B3 is blank, leave current cell blank.
I've tried several things but can't make it work. This is my first conditional formula.
Thanks!
If B3 is greater than zero, calculate A3+72 (A3 is a date field)
If B3 is less than zero, leave cell blank.
I could also use if B3 is not blank, calculate A3+72
If B3 is blank, leave current cell blank.
I've tried several things but can't make it work. This is my first conditional formula.
Thanks!
