Dec 02 2022 06:11 AM
I need to calculate the following - appreciate anyones help...!!
Dec 02 2022 06:34 AM
Try this:
=IF(LEFT(CELL("format";B1))="D";A1*0.25;0)
Hope this is the correct translation, I only have got the german version.
Worti
Dec 02 2022 08:29 AM
@Der_Worti thanks for your help but it didn’t work. Tried changing the apostrophe for a comma but that didn’t work either….
Dec 04 2022 09:02 AM
CELL("format") returns "G" for default date format CELL function - Microsoft Support
If in column B could be date or nothing, easier way is to check if it is empty or not.
Dec 04 2022 10:44 AM