Forum Discussion
XL formula query
I need to calculate the following - appreciate anyones help...!!
4 Replies
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.
WortiDer_Worti thanks for your help but it didn’t work. Tried changing the apostrophe for a comma but that didn’t work either….
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.
