Lisa McConachy
New Member
- Joined
- Jan 24, 2020
- Messages
- 11
- Office Version
- 365
- Platform
- Windows
I have the following formula that I want to return only the numbers after the /. Can I add to the formula to remove the prefix also? Very New to excel!!
=IF('Field Data Entry'!$AE$17<'Field Data Entry'!$C$19,"",IF('MDD 1_Data Entry'!$F$6="","",'MDD 1_Data Entry'!$F$6))
MDD 1_Data Entry'!$F$6 = AAA20/100
=IF('Field Data Entry'!$AE$17<'Field Data Entry'!$C$19,"",IF('MDD 1_Data Entry'!$F$6="","",'MDD 1_Data Entry'!$F$6))
MDD 1_Data Entry'!$F$6 = AAA20/100