Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

Compare 2 dates and output a specific word in a third field

I have a simple nested IF statement that works correctly in Excel, but in translating it to QB, it fails. Excel Formula:   =IF([Date Received] < $E$3, "GW", IF([Date Received] < $E$4, "INVERTER"...
JohnThomas's avatar
JohnThomas
Qrew Cadet
8 years ago
Use the below formula, Default value will be none and you will get both values based on conditions

If([Date Received] < [Recloser Date], "GW", 
If([Date Received] > [Recloser Date], "GOOD" ))

I hope this will solve your problem