Tryingtoresolve
New Member
- Joined
- Aug 28, 2023
- Messages
- 24
- Office Version
- 365
- Platform
- Windows
I am trying to get a formula to work I can get each part to work separately but not together plus show NA if no return the formula I am looking at is =IF(E2="HOLD",J2+120)*IF(E2="SALE",J2+30) I can get it to sort of work but J2 is a date and it just returns 00/01/1900 for the formula but works correct if it's just =IF(E2="HOLD",J2+120)