XL formula query

[BenBen1125]

I need to calculate the following - appreciate anyones help...!!

[#2]

@BenBen1125 

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

[#3]

@Der_Worti thanks for your help but it didn’t work. Tried changing the apostrophe for a comma but that didn’t work either….

[#4]

@BenBen1125 

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.

[#5]

I am interested in providing a reply to this question. Let me do some researches to provide answers to your questions