Forum Discussion
I need formula help!
XxFiFTy2xX Try this:
=IF(ISNUMBER(Sheet3!C4),C87,IF(Sheet3!C4="SKIPPED",0,""))
Note that in Excel, dates are in fact sequential numbers starting at 1 for January one, 1900. so, today's date is day number 45017. Thus, the first IF checks if a number is entered. If true then return C87. If false, check if the word SKIPPED is entered (not case-sensitive, by the way). If true then return 0, if false return an empty string.
XxFiFTy2xX Try this:
=IF(ISNUMBER(Sheet3!C4),C87,IF(Sheet3!C4="SKIPPED",0,""))
Note that in Excel, dates are in fact sequential numbers starting at 1 for January one, 1900. so, today's date is day number 45017. Thus, the first IF checks if a number is entered. If true then return C87. If false, check if the word SKIPPED is entered (not case-sensitive, by the way). If true then return 0, if false return an empty string.
Riny_van_Eekelen thank you so much! That formula did exactly what I was looking to do!